Forum Discussion

JustinDoh1's avatar
JustinDoh1
Post Prodigy
2 years ago
Solved

How to pass filter value into a variable?

I have using measure that has all static value for filter values (in this case: FacilityCode).

Bottom is just one example of a measure.

 

 

Now, I came across the point, this approach is not possible because I need to use Filter/Slicer to put the value here using Variable possibly (yellow area) - dynamic approach.

 

How do I go about doing it?

 

Do I create another measure for the value of Filter and plug here?

 

 

 

4 Replies

  • replace the yellow part with VALUES(SlicerTable[SlicerField])

    • JustinDoh1's avatar
      JustinDoh1
      Post Prodigy

      vicky_  Thank you so much for your help.

      I am getting this error:

      I was modifying code here:

       

       

      • lbendlin's avatar
        lbendlin
        Super User

        remove the curly brackets