Forum Discussion

curtismob's avatar
curtismob
Icon for Helper IV rankHelper 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
Icon for Advocate I rankAdvocate I
2 years ago

Could it be this simple?

 

  • curtismob's avatar
    curtismob
    Icon for Helper IV rankHelper IV
    2 years ago

    Unfortunately not, the requirement is to be able to toggle on/off including all values or exclude where the 'Option Cost'[_mOption Cost Code Count Diff] measure is zero.

    • curtismob's avatar
      curtismob
      Icon for Helper IV rankHelper 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])