COMBINA DAX Function (Statistical)

Syntax  |  Return values  |  Remarks  |  Related  

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

Syntax

COMBINA ( <Number>, <Number_chosen> )

Parameter	Attributes	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

Scalar A single integer value.

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

Remarks

Numeric arguments are rounded to integers.

Related functions

Other related functions are:

• COMBIN

Last update: Jan 11, 2021   » Contribute   » Show contributors

Contributors: Alberto Ferrari, Marco Russo

MSDN documentation: https://docs.microsoft.com/en-us/dax/combina-function-dax