cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Employee

## Measures that Sum by another field in table?

Is it possible to create

a. TotalForWeek - Total of all Result values for a particular Week?

b. PctOfTotal - Divide an individual Result by TotalForWeek?

Sample data below

 PART Week Result TotalForWeek PctOfTotal PART B 06/29/2020 928 54,701 1.70% PART C2 06/29/2020 283 54,701 0.52% PART S 06/29/2020 55 54,701 0.10% PART X 06/29/2020 23,425 54,701 42.82% PART A 06/29/2020 30,010 54,701 54.86% PART B 07/07/2020 2,562 41,235 6.21% PART C2 07/07/2020 26,223 41,235 63.59% PART S 07/07/2020 3,472 41,235 8.42% PART X 07/07/2020 8,755 41,235 21.23% PART A 07/07/2020 223 41,235 0.54% PART B 07/21/2020 665 13,703 4.85% PART C2 07/21/2020 9,342 13,703 68.17% PART S 07/21/2020 577 13,703 4.21% PART X 07/21/2020 464 13,703 3.39% PART A 07/21/2020 2,655 13,703 19.38%
1 ACCEPTED SOLUTION
Super User

@jch here are the measures:

``````Sum Result = SUM ( 'Table'[Result] )

Sum Week = CALCULATE ( [Sum Result], REMOVEFILTERS ( 'Table'[PART] ) )

% = DIVIDE ( [Sum Result], [Sum Week] )``````

Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

2 REPLIES 2
Super User

Hi,

Hope this helps.

Regards,
Ashish Mathur
http://www.ashishmathur.com
Super User

@jch here are the measures:

``````Sum Result = SUM ( 'Table'[Result] )

Sum Week = CALCULATE ( [Sum Result], REMOVEFILTERS ( 'Table'[PART] ) )

% = DIVIDE ( [Sum Result], [Sum Week] )``````

Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

#### Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors