Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Use measure as filter

Hi everyone!   I'm trying to filter a table by a value that is stored in a measure. I'm not being able to do it. Is it even possible?   For example: I want to show in a visualization just the acc...
Need Help
  • v-henryk-mstf's avatar
    v-henryk-mstf
    4 years ago

    Hi Anonymous ,

     

    Measure cannot be used as a slicer, but a similar effect can be achieved in other ways:

    Switch =
SWITCH (
    SELECTEDVALUE ( Table_2[Date] ),
    DATE ( 2022, 01, 01 ), [Measure1],
    DATE ( 2022, 01, 02 ), [Measure2],
    DATE ( 2022, 01, 03 ), [Measure3]
)

     

     

    If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


    Best Regards,
    Henry


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-henryk-mstf's avatar
v-henryk-mstf
Community Support
4 years ago

Hi Anonymous ,

 

Measure cannot be used as a slicer, but a similar effect can be achieved in other ways:

Switch =
SWITCH (
    SELECTEDVALUE ( Table_2[Date] ),
    DATE ( 2022, 01, 01 ), [Measure1],
    DATE ( 2022, 01, 02 ), [Measure2],
    DATE ( 2022, 01, 03 ), [Measure3]
)

 

 

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


Best Regards,
Henry


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thanks for your help. It was very clear. But I had some troubles with it so I decided to use a new input with the info I wanted to store in the measure and it's working. 

    Thanks again.