COMBINA

Applies to: Calculated column Calculated table Measure Visual calculation

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

Syntax

DAX

COMBINA(number, number_chosen)

Parameters

Term	Definition
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 value

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.

Example

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