COMBINA Function (DAX)

How does the COMBINA function (DAX) work?

The COMBINA function (DAX) is a math and trigonometry function that returns the number of combinations (with repetitions) for a given number of items.

COMBINA Formula Syntax

COMBINA(
     number, number_chosen
)

How do you use the COMBINA function?

This function is used to calculate the number of combinations (with repetitions) of a given number objects from a set.

Related Blog Posts

Related Support Forum Posts

DAX Virtual Table Logic to modify Context
DATEADD within SUMX returning 0 or blank
Problem With SUMX With IF

Considerations when using the COMBINA function

If the value of either argument is outside of its constraints, COMBINA returns a #NUM! error message. If either of the argument is non-numeric, the function will return the #VALUE! error.

Related Video Tutorials

Formula examples using the COMBINA function

=COMBINA(4,3)

=COMBINA(10,3)

=COMBINA(21, 5)

Related Course Modules

Ultimate-Beginners-Guide-To-PowerBI
Center of Excellence

DOWNLOAD


Download our comprehensive DAX Formula Reference Guide as perfect companion as you learn how to use DAX formulas within Power BI.


Download DAX Formulas Reference Guide
Download DAX Formula Reference Guide
Membership