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:

COMBINA Formula

Related Video Tutorials

Formula examples using the COMBINA function

=COMBINA(4,3)

=COMBINA(10,3)

=COMBINA(21, 5)

Related Course Modules

Ultimate-Beginners-Guide-To-PowerBI

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.