COMBINA Function (DAX)
How does the COMBINA function (DAX) work?
The COMBINA function (DAX) 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?
Used Combina function to calculate the number of combinations, with repetitions, of a given number objects from a set.
Related Blog Posts
Related Support Forum Posts
Understanding DAX Formula
Developing Complex Dax functions
Considerations when using the COMBINA function
If the value of either argument is outside of its constraints, COMBINA returns the #NUM! error value.
If either argument is a non-numeric value, COMBINA returns the #VALUE! error value.
The following equation is used, where N is Number and M is Number_chosen:
Related Video Tutorials
Formula examples using the COMBINA function
=COMBINA(4,3)
=COMBINA(10,3)
=COMBINA(21, 5)
Related Course Modules
DOWNLOAD
To access our comprehensive DAX formula reference guide just insert your email address below. The resource will download immediately and we’ll also email it to you.
