How to do it...

To implement this recipe, perform the following steps:

  1. 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])
  1. On a Report page, create a Slicer visualization and place the Color column from R04_Table in the Field area of the visualization.
  2. On the same Report page, create a Card visualization and place the My Sum measure in the Fields area of the visualization.
  3. On the same Report page, create a second Card visualization and place the My Sum Debug measure in the Fields area of the visualization.