Forum Discussion

Nafeesa's avatar
Nafeesa
Frequent Visitor
3 years ago

Dynamic comparison measure between two filtered measures

I have two tables showing sales with dynamic date filters;     I want to create measure to compare the % difference between the values on the left vs right, however I can't get the date rang...
Need Help
DimaMD's avatar
DimaMD
Icon for Solution Sage rankSolution Sage
3 years ago

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

Nafeesa's avatar
Nafeesa
Frequent Visitor
3 years ago

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. 

  • DimaMD's avatar
    DimaMD
    Icon for Solution Sage rankSolution Sage
    3 years ago

    Nafeesa Please provide the pbix file.