Forum Discussion

DimaMD's avatar
DimaMD
Icon for Solution Sage rankSolution Sage
5 years ago
Solved

Measure slicer filter DAX

Is it possible to write a measure or a table that would filter the measure
Example matrix

ProductsalesMesure
a100AX
b80BX
c50CY
d30AY

 

thanks for the help

@help

4 Replies

    • DimaMD's avatar
      DimaMD
      Icon for Solution Sage rankSolution Sage
      5 years ago

      Ні,smpa01
      I have a measure that shows ABC XYZ analysis
      The customer wants to filter the value shown by the measure
      Is it possible to create a slicer to filter the measure
       

      • smpa01's avatar
        smpa01
        Icon for Community Champion rankCommunity Champion
        5 years ago

        DimaMD  you can not use values from a measure to feed in a slicer. But you can build a disconnected table with input as all the unique values generated by the measure.

         

        Then you can write a measure with SELECTEDVALUE and SWITCH so that the end user can filter the viz with values coming fromthat disconnected table.

         

        https://www.youtube.com/watch?v=AHiCE1N0XHE&t=20s