Compare the value of a column in one visual to a column in another visual

[Chris_G_TP]

Hello all,

I am trying to compare the value of a column in one visual to a column in another visual.  The underlying table is the same for both visuals but using separate queries, one for each visual.  The Date Slicer is linked to the first visual and the Date_2 slicer is linked to the second.  When I sunbtract vol% from vol_2% I get 0, some research showed me that even though the Vol% is a calculated column or a variable defined in the first visual, the Date2 slicer is contolling the first table. I've tried turning relationship on and off with no change in results, also tried related does not support computed columns in the visual

So my question is this, how can I pull the values from the Date Slicer to be used in a query by the Date_2 Visual?  I've tried

End_Date = CALCULATE(MAX(CALL_TYPE_COMBINED[Date]),ALLSELECTED(CALL_TYPE_COMBINED)). However that

references the table and not the slicer and I end up with the same results.

Any insight on how to solve this would be greately apreciated.

[amitchandak]

@Chris_G_TP , Need to understand how you have done it. If volume1 and volume2 have same formula(same table) other than date range then one of them has to use independent date table for range

refer my video example

How to use two Date/Period slicers :https://www.youtube.com/watch?v=WSeZr_-MiTg

or

 Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Chris_G_TP · Accepted solution]

I tried setting up an unrelated table using the dates from the primary table, however that did not work.  I resolved my issue by using one visual then changing from a computed column to a measure.  I then used CALCULATE with it's own set of filters to retrive the month to date data.