Forum Discussion
Create a slicer using a measure
Hello, I have a matrix defined with the following columns as rows. Options[Category Description], Options[Option], Community[_cCommunity with Number], Options[_cPlan/Elev], 'Option Cost'[Cost C...
Here is a link to a simplified pbix version.
https://drive.google.com/file/d/1VJVRq6bPfmauzXdbOVCdVSbUUQD2Lo-t/view?usp=sharing
This screen shot is from the link provided previously.
Below is the calculated table used for the slicer, which has a relationship set with the Option table.
_tCost Code Count Slicer =
SUMMARIZE(
Option,
Option[Community],
Option[Plan/Elev],
"CountDiff", 'OptionCost'[_mCost Code Count Diff])