topic Re: How to pass filter value into a variable? in DAX Commands and Tips

How to pass filter value into a variable?

JustinDoh1 — Wed, 28 Feb 2024 00:09:20 GMT

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?

Re: How to pass filter value into a variable?

lbendlin — Wed, 28 Feb 2024 02:55:51 GMT

read about VALUES() and about FILTERS()

Re: How to pass filter value into a variable?

vicky_ — Wed, 28 Feb 2024 03:18:42 GMT

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

Re: How to pass filter value into a variable?

JustinDoh1 — Thu, 29 Feb 2024 00:28:58 GMT

vicky_ Thank you so much for your help.

I am getting this error:

I was modifying code here:

Re: How to pass filter value into a variable?

lbendlin — Thu, 29 Feb 2024 00:38:45 GMT

remove the curly brackets