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.
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 ) )
}
| Value1 | Value2 |
|---|---|
| COMBINA ( 3, 1 ) | 3 |
| COMBINA ( 3, 2 ) | 6 |
| COMBINA ( 3, 3 ) | 10 |
| COMBINA ( 4, 1 ) | 4 |
| COMBINA ( 4, 2 ) | 10 |
| COMBINA ( 4, 3 ) | 20 |
| COMBINA ( 4, 4 ) | 35 |
Related functions
Other related functions are:
Last update: Apr 2, 2021 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
Microsoft documentation: https://docs.microsoft.com/en-us/dax/combina-function-dax
2018-2021 © SQLBI. All rights are reserved. Information coming from Microsoft documentation is property of Microsoft Corp. » Contact us » Privacy Policy & Cookies