COMBINA DAX Function (Statistical)

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.

» 1 related function

Examples

--  COMBINA returns the number of possible combinations of
--  a given number of items WITH repetitions.
--  The internal order is not relevant.
--  Use COMBIN to compute combinations WITHOUT repetitions.
--
--  For example, consider 3 elements ( A, B, C )
--  COMBINA ( 3, 2 ) returns 6 counting:
--       ( A, A )
--       ( B, B )
--       ( C, C )
--       ( A, B )
--       ( B, C )
--       ( A, C )
EVALUATE 
{
    ( "COMBINA ( 3, 1 )", COMBINA ( 3, 1 ) ),
    ( "COMBINA ( 3, 2 )", COMBINA ( 3, 2 ) ),
    ( "COMBINA ( 3, 3 )", COMBINA ( 3, 3 ) ),
    ( "COMBINA ( 4, 1 )", COMBINA ( 4, 1 ) ),
    ( "COMBINA ( 4, 2 )", COMBINA ( 4, 2 ) ),
    ( "COMBINA ( 4, 3 )", COMBINA ( 4, 3 ) ),
    ( "COMBINA ( 4, 4 )", COMBINA ( 4, 4 ) )
}