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
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
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
Related Course Modules
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.