Create % comparison value between two visuals.

[Anonymous]

I am trying to create a new dynamic comparison metric between two table visuals with identical metrics and custom date slicers that create a period A/B view.

Both tables and date slicers reference the same dataset (tableA). I want to create a measure that can calculate the % difference for all metrics between periods A and B, either as a new table or a series of scorecards under the period B table.

For simplicity, I am only using Cost and Date from the table to create these different periods for comparison.

I am not a DAX expert, so I am running into issues with creating my measure since it relies on the same data set. The closest I got was by duplicating my dataset (tableA (1)) so that I could reference the same metric in my calculation, i.e. %_Change_Cost=(SUM(('tableA'[Cost])/('tableA (1)'[Cost]))-1. But when the date filters do not overlap, the calculation breaks.

Thank you!

[amitchandak · Accepted solution]

@Anonymous , BAsed on what I got, You need a set of independent tables

Refer this was done using interaction

How Interactions Work- Split Page using interactions to compare - https://youtu.be/GIfRKzhMaR4

same thing using two sets of slicer

Compare Categorical Data Using Slicers - Compare two Brands: https://youtu.be/exN4nTewgbc

How to use two Date/Period slicers

https://youtu.be/WSeZr_-MiTg