Skip to main content
cancel
Showing results for 
Search instead 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

Reply
Andi_R
Frequent Visitor

Sum subcategories for each category

Hi Everyone! I'm new to power bi and am still learning DAX measures, so any help/advice is very much appreciated! I'm currently trying to make a measure that adds the subcategroies to then be defined by the categories. Unfortunately my orgs settings does not allow me to share even a test pbix, so I encluded a test excel screenshot: 

Andi_R_0-1720644957543.png

So for example, I'm looking to add A1+A2, B1+B2, C1+C2, & D1+D2 to get: A, B, C, & D.

How would I go about making this measure?

Thank you in advance for any help!!

1 REPLY 1
PhilipTreacy
Super User
Super User

Hi @Andi_R 

 

Download example PBIX file

 

You don't need to write a measure for this, PBI does it for you.

 

After entering the data into PBI, add a table and add the Category and Total

 

sumcats.png

 

Regards

 

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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