Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have a Measures providing me the median minutes per Single Item producted-->
Solved! Go to Solution.
Try somthing like this. It will build a list of the values in the Fase column, add the result of the measure and sum up the values.
Median Sum = SUMX ( VALUES ( 'Timbrature'[Fase] ), [@MinRealPz] )
Sum in measures only calculates the current row, you need set the condition to all(table).
Measure = CALCULATE(SUM([@MinRealPz]), All(Table))
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
Try somthing like this. It will build a list of the values in the Fase column, add the result of the measure and sum up the values.
Median Sum = SUMX ( VALUES ( 'Timbrature'[Fase] ), [@MinRealPz] )
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |