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

     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(21, 5)

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.