To complete this recipe, do the following:
- 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
)
- 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.
- 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.
- 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.
- On the same Report page, create a Card visualization and place the Sample Size measure into the Field area of the visualization.