Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn 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 |
---|---|
49 | |
40 | |
18 | |
14 | |
13 |
User | Count |
---|---|
100 | |
55 | |
28 | |
18 | |
13 |