Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
giroldoale
Helper I
Helper I

SUM of a Measures that divides

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..
 
MinSum.png
1 ACCEPTED SOLUTION
jdbuchanan71
Super User
Super User

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

View solution in original post

2 REPLIES 2
V-pazhen-msft
Community Support
Community Support

@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
Super User
Super User

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.