How can I compare dates selected from two separate slicers?

You may create 2 different instances of date table and join with your main / fact table. And then put slicer based from those 2 different date tables and also create 2 set of count measures based on 2 date tables.

If this resolves your problem, then please mark it as Solution, thanks!

Hi samratpbi , danextian ,thanks for the quick reply, I'll add more.

Hi vivaldii ,

The Table data is shown below:

Please follow these steps:
1. Use the following DAX expression to create a table named ‘Table2’

Table 2 = CALENDAR(DATE(2024,1,1),DATE(2024,12,31))

 2. Use the following DAX expression to create a table named ‘Table3’ 

Table 3 = CALENDAR(DATE(2024,1,1),DATE(2024,12,31))

3. Use the following DAX expression to create a measure

Measure = CALCULATE( SUMX(FILTER('Table','Table'[Date] = SELECTEDVALUE('Table 2'[Date])),[Number]),ALL('Table 3'[Date]))

4. Use the following DAX expression to create a measure

Measure 2 = CALCULATE( SUMX(FILTER('Table','Table'[Date] = SELECTEDVALUE('Table 3'[Date])),[Number]),ALL('Table 2'[Date]))

5. Use the following DAX expression to create a measure

Measure 3 = [Measure 2] - [Measure]

6. Use the following DAX expression to create a measure

Measure 4 = DIVIDE([Measure 3],[Measure 2])

7. Final output

Best Regards,
Wenbin Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.