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