Summarise Median values for a product but plus the median values based on productionlap

[TcT85]

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

[Ashish_Mathur · Accepted solution]

Hi,

Write these measures

Measure = MEDIAN(Data[Time])

Measure 2 = SUMX(VALUES(Data[ProductionLap]),[Measure])

Hope this helps.

[AndyEagleton]

Median = SUMX(VALUES(Data[ProductionLap]), CALCULATE(MEDIAN(Data[Time])))