Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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?
Solved! Go to Solution.
replace the yellow part with VALUES(SlicerTable[SlicerField])
remove the curly brackets
read about VALUES() and about FILTERS()
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 19 | |
| 13 | |
| 9 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 30 | |
| 27 | |
| 17 | |
| 11 | |
| 10 |