Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Nafeesa
Frequent Visitor

Dynamic comparison measure between two filtered measures

I have two tables showing sales with dynamic date filters;

 

Nafeesa_1-1672842873627.png

 

I want to create measure to compare the % difference between the values on the left vs right, however I can't get the date range filters to apply correctly. The measure I'm trying to use is the below;

 

Saless Diff % = iferror(IFERROR( [Total Saless] - [Total Saless Period 2], 0 )/[total saless],0)

 

 

I've attached some sample data and how I would like it to work using excel and pivot tables.

 

3 REPLIES 3
DimaMD
Solution Sage
Solution Sage

Hi, @Nafeesa  Do you have 2 fact tables please? what does your table relationship model look like?
Can you provide dummy data for testing?


__________________________________________

Thank you for your like and decision

__________________________________________

Greetings from Ukraine

To help me grow PayPal: embirddima@gmail.com

HI Dima, 

There is just the one fact table with the data, presented in two different tables with date slicers.
I've attached some sample data. 

@Nafeesa Please provide the pbix file.


__________________________________________

Thank you for your like and decision

__________________________________________

Greetings from Ukraine

To help me grow PayPal: embirddima@gmail.com

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.