Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Dinamically switch between two date fields and measures using slicer

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?

calculated column
DAX
Formula
Slicer

1 Reply

  • tamerj1's avatar
    tamerj1
    Community Champion
    3 years ago

    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.