How to do it...

To complete this recipe, do the following:

  1. Create the following measures:
Confidence Value = SELECTEDVALUE('R11_2TailZScores'[Confidence],.95)

Precision Value = SELECTEDVALUE('R11_Precision'[Precision],.05)

Proportion Value = SELECTEDVALUE('R11_Proportion'[Proportion],.5)

Sample Size =
VAR __ZScore =
LOOKUPVALUE(
'R11_2TailZScores'[Z-Score],
'R11_2TailZScores'[Confidence],
[Confidence Value]
)
RETURN
DIVIDE(
__ZScore^2 * [Proportion Value] * (1 - [Proportion Value]),
[Precision Value]^2,
0
)
  1. On a Report page, create a Slicer visualization, place the Confidence column from the R11_2TailZScores table into the Field area of the visualization, and format the slicer as a Dropdown.
  2. On the same Report page, create a second Slicer visualization, place the Precision column from the R11_Precision table into the Field area of the visualization, and format the slicer as a Dropdown.
  3. On the same Report page, create a third Slicer visualization, place the Proportion column from the R11_Proportion table into the Field area of the visualization, and format the slicer as a Dropdown.
  4. On the same Report page, create a Card visualization and place the Sample Size measure into the Field area of the visualization.