COMBINA

COMBINA is a DAX function that returns the number of combinations with repetitions for a given number of items.

Syntax

COMBINA(
   Number,
   Number_chosen
)

Argument	Properties	Description
Number		Must be greater than or equal to 0, and greater than or equal to Number_chosen. Non-integer values are truncated.
Number_chosen		Must be greater than or equal to 0. Non-integer values are truncated.

Return Values

Returns the number of combinations (with repetitions) for a given number of items.

Remarks

• 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:

  $$(\genfrac{}{}{0ex}{}{N+M-1}{N-1})$$

• This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.

Formula	Description	Result
= COMBINA(4,3)	Returns the number of combinations (with repetitions) for 4 and 3.	20
= COMBINA(10,3)	Returns the number of combinations (with repetitions) for 10 and 3.	220

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/dax/combina-function-dax