How to do it...

To complete this recipe, do the following:

  1. Create the following measures:
Row Count = COUNTROWS('R09_Table')

Permutations =
VAR __Table =
SELECTCOLUMNS(
'R09_Table',
"__Key1",'R09_Table'[DimKey1],
"__Key2",'R09_Table'[DimKey2],
"__Key3",'R09_Table'[DimKey3]
)
RETURN
COUNTROWS(DISTINCT(__Table))
  1. On a Report page, create a Card visualization and place the Row Count measure into the Fields area of the visualization.
  2. On the same Report page, create a second Card visualization and place the Permutations measure into the Fields area.

We can see that the Permutations measure has correctly identified that ID 1 and ID 10 are the same.