Dinamically switch between two date fields and measures using slicer

[Anonymous]

Hi everyone, 

I'm trying to create a matrix, which can show different calculations depending on slicer selection:

For example if Sellout is selected in slicer 1, and Base Volume (Kg) is selected in slicer 2, then the matrix will show SUM(Fact_Sales[Base Volume (Kg)], and so on.

This is working as intended at the moment, however, the Date Field in the matrix columns also needs to change depending on what is chosen on slicer 1: 

SellIn -> Date field should be F_Sales[Sellin_Date]
SellOut -> Date field should be F_Sales[Sellout_Date]

Any ideas?

[tamerj1]

Hi @Anonymous 
If you have an inactive relationship between 'Date'[Date] and F_Sales[Sellout_Date] then you need to use CALCULATE - USERELATIONSHIP to activate that relationship when calculating SellOut. If you don't have such realtionship created already then create it.