COMBIN Function (DAX)

How does the COMBIN function (DAX) work?

The COMBIN function (DAX) is a type of math and trigonometry DAX function that returns the number of combinations for a given number of items.

COMBIN Formula Syntax

COMBIN(
     number, number_chosen
)

How do you use the COMBIN function?

This DAX function is used to determine the total possible number of groups for a given number of items.

Related Blog Posts

Related Support Forum Posts

Want grand total of average function to be a sum not an average
Moving average not average
SUMX not calculating correctly

Considerations when using the COMBIN function

The COMBIN function has two arguments: the required number of items and the required number of items for each combination.

Related Video Tutorials

Formula examples using the COMBIN function

=COMBIN(A1, A2)

=COMBIN(A1, A3)

=COMBIN(8,2)

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.