How to do it...

To implement this recipe, perform the following steps:

  1. Create the following measures:
My Standard Deviation = 
VAR __Table = ALLSELECTED('R04_Table')
RETURN
STDEVX.P(__Table,[Value])

My Standard Deviation Debug =
VAR __Table = ALLSELECTED('R04_Table')
RETURN
//STDEVX.P(__Table,[Value])
FIRSTNONBLANK(
SELECTCOLUMNS(
__Table,
"__Value",[Value]
),
[__Value]
)
& "," &
LASTNONBLANK(
SELECTCOLUMNS(
__Table,
"__Value",[Value]
),
[__Value]
)
  1. On a Report page, create a Slicer visualization and place the Color column from R06_Table in the Field area of the visualization.
  2. On the same Report page, create a Card visualization and place the My Standard Deviation measure in the Fields area of the visualization.
  3. On the same Report page, create a second Card visualization and place the My Standard Deviation Debug measure in the Fields area of the visualization.