Calculate the variation between 2 filtered numbers

[JEM_Systems]

Hi, I'm trying to calculate a variation between two numbers, the first number is only interacting with the first slicer, the second number is interacting with just the second slicer; I'm trying to calculate the diferences between them but it's giving me just Blank.

[Ashish_Mathur]

Hi,

Share the download link of the PBI file.

[JEM_Systems]

Already did it, thank you!

[Ashish_Mathur]

Alreay did what?  Where is the file?

[JEM_Systems · Accepted solution]

I solved the problem creating 2 calendar tables, each one for each slicer, and did a relationship between the calendar tables and the fact table using a inactive relationship. On the DAX formula I used USERELATIONSHIP() to solve the problem.

[JEM_Systems]

@amitchandak could you help me?