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!View all the Fabric Data Days sessions on demand. View schedule
Hi all,
So I have this issue which I've been struggling with for quite a while now...
My users want to use the same filter three times in the same PowerBI report affecting three different measures. Hence, I need to write a DAX-calculation which separates the selected filter values (e.g. year 2018 for filter a, year 2017 for filter b etc.). Unfortunately, all the workarounds that I tried resulted in a table with blank values (see image below). Presumably the table turns blank because I’m using the same filter three times with different values…
Suggestions/workarounds are highly appreciated!
I did not get it completely
But there something similar here
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/Winner-Topper-on-Map-How-to-Color-States-on-a-Map-wi...
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p...
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!