To complete this recipe, do the following:
- 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))
- On a Report page, create a Card visualization and place the Row Count measure into the Fields area of the visualization.
- 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.