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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Anonymous
Not applicable

How do i take the Sum of a Calculated Measure

Hello -

I have a Measure that is calculating the number of staff required  based on call volumes and length of calls and am looking to aggregate that measure as a total for the day and eventually week.

 

My measure currently shows the daily staff required for the day's average by hour instead of the total for the day . Is there a way to take the sum of this measure? 2+7+11+12+12+11+13+13+12+10 = 93 required instead of 11


turtles25_0-1630623452790.png

 

 

In the above example i just need the bottom row to show the total for the day similar to how the # of calls is displayed.

 

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Anonymous , Try measure like

 


sumx(values(Table[Hour]),[Required])

 

or

 

sumx(summarize(Table[Hour], "_1",[Required]),[_1])

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@Anonymous , Try measure like

 


sumx(values(Table[Hour]),[Required])

 

or

 

sumx(summarize(Table[Hour], "_1",[Required]),[_1])

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Anonymous
Not applicable

Thank you @amitchandak 

 

The Sumx Values is doing exactly what I was looking for

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

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