Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Hi @vrumay2
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.
User | Count |
---|---|
54 | |
23 | |
19 | |
18 | |
17 |
User | Count |
---|---|
91 | |
86 | |
46 | |
28 | |
22 |