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
Center of Excellence

DOWNLOAD


Download our comprehensive DAX Formula Reference Guide as perfect companion as you learn how to use DAX formulas within Power BI.


Download DAX Formulas Reference Guide
Download DAX Formula Reference Guide
Membership