Forum Discussion

curtismob's avatar
curtismob
Helper IV
2 years ago

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...
Need Help
Daniel_PowerBI's avatar
Daniel_PowerBI
Advocate I
2 years ago

Could it be this simple?

 

  • curtismob's avatar
    curtismob
    Helper IV
    2 years ago

    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])