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
Hello,
I have a matrix where I analyse my sales by client with variations between two years. The variations is a measure I created with the functions "SAMEPERIODLASTYEAR". I have as many lines as client. I want to have a segment that make users choose if they want to analyse positive variations or negative variations of sales.
How to make it work?
Thank you, I don't know if it's very simple or complicated.
Solved! Go to Solution.
You can create a disconnected table with the segments
And create a dynamic measure like :
* Delta tested is just a delta between 2 measures like in your scenario.
The pbix is attached.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
You can create a disconnected table with the segments
And create a dynamic measure like :
* Delta tested is just a delta between 2 measures like in your scenario.
The pbix is attached.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
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!