PERMUT - Daxplained

PERMUT is a DAX function that returns the number of permutations for a given number of objects selected from a total number of objects, where order is significant.

Syntax

PERMUT(
   Number,
   Number_chosen
)

Argument	Properties	Description
Number		An integer that describes the number of objects.
Number_chosen		An integer that describes the number of objects in each permutation.

Return Values

Returns the number of permutations for a given number of objects that can be selected from number objects

Remarks

Both arguments are truncated to integers.
If number or number_chosen is nonnumeric, PERMUT returns the #VALUE! error value.
If number ≤ 0 or if number_chosen < 0, PERMUT returns the #NUM! error value.
If number < number_chosen, PERMUT returns the #NUM! error value.
The equation for the number of permutations is:

$P_{k, n} = \frac{n!}{(n - k)!}$
This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.

Example

In the following formula, permutations possible for a group of 3 objects where 2 are chosen:

= PERMUT(3,2)

Result,

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