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...
calculated column
DAX
Formula
Slicer
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity 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.