SUM of a Measures that divides

[giroldoale]

Hi,

I have a Measures providing me the median minutes per Single Item producted--> 

@MinRealPz = CALCULATE(MEDIAN(Timbrature[MinLAvPz]))

I have a table vizualizing the Measures @MinRealPz for every step of production.

I need to write a Measures providing me the SUM of the @MinRealPz

--> I try to do the script-->CALCULATE(SUM([@MinRealPz]))

But it doesen't work, seems like I can't insert into SUM a Measure.

Can you help me?

I have to obtain the sum of the column in azure..

[V-pazhen-msft]

@giroldoale 

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.

[jdbuchanan71 · Accepted solution]

@giroldoale 

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] )