Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
HI,
Need help to write a DAX formula to get the MEDIAN values on Time for each Product but I need to summarise the production median time for each product as well.
For example.
Product A with production lap 1 has a median value of 6,5 and production lap 2 has a median value 5,5,
For product A I need to show 12.
For product B I need to show 8,5.
Data Table
Product | SerialNumber | ProductionLap | Time |
A | 1 | 1 | 7 |
A | 1 | 2 | 8 |
A | 2 | 1 | 6 |
A | 2 | 2 | 7 |
A | 3 | 1 | 4 |
A | 3 | 2 | 4 |
A | 4 | 1 | 7 |
A | 4 | 2 | 4 |
B | 5 | 1 | 7 |
B | 6 | 1 | 8 |
B | 7 | 1 | 9 |
B | 8 | 1 | 16 |
Solved! Go to Solution.
Hi,
Write these measures
Measure = MEDIAN(Data[Time])
Measure 2 = SUMX(VALUES(Data[ProductionLap]),[Measure])
Hope this helps.
Hi,
Write these measures
Measure = MEDIAN(Data[Time])
Measure 2 = SUMX(VALUES(Data[ProductionLap]),[Measure])
Hope this helps.
User | Count |
---|---|
80 | |
74 | |
63 | |
61 | |
45 |
User | Count |
---|---|
108 | |
98 | |
89 | |
82 | |
61 |