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)

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.