Calculate measures in same visual depend 2 slicer

[freginier]

Hi all, 

I would like to create Measure1 depend Date Slicer 1 and Measure 2 depend Date Slicer 2 

I know how to do this in 2 visuals but how to do this in a table ?

I can't use SELECTEDVALUE function because both slicer have start and end date

Thank you !  

[mahoneypat · Accepted solution]

You likely need to create 2 disconnected tables to do this. An easy way is the just make DAX tables with the DISTINCT() function on the needed column from your primary date table. You would then have no relationship to the other tables ("disconnected"), and then harvest the slicer value with SELECTEDVALUE() to use in your measure(s).

Pat