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)