To implement this recipe, perform the following steps:
- Create the following measures:
My Average =
VAR __Table = ALLSELECTED('R04_Table')
RETURN
AVERAGEX(__Table,[Value])
My Average Debug =
VAR __Table = ALLSELECTED('R04_Table')
RETURN
COUNTROWS(__Table) //AVERAGEX(__Table,[Value])
- On a Report page, create a Slicer visualization and place the Color column from R05_Table in the Field area of the visualization.
- On the same Report page, create a Card visualization and place the My Average measure in the Fields area of the visualization.
- On the same Report page, create a second Card visualization and place the My Average Debug measure in the Fields area of the visualization.