Sum the maximum values of each category

Power BI
1

Hi everyone, I’m stuck on this problem.
I need to find the maximum values within a category and then sum the results.
I’m looking for 3 DAX measure to do this.
I’m uploading the file and hopefully someone can help.

Many thanks,
MustafaExpats.pbix (37.9 KB)

2

Hello @chris786,

Thank You for posting your query onto the Forum.

Well, I’ve created a combination of two-fold type of formulas to achieve the results that you’re looking for. Firstly, I created a formula to find out the MAX by each of the categories and than to calculate the correct grand totals.

Below is the screenshot provided of the results for the reference -

Results
Results1167×675 44 KB

I’m attaching the working of the PBIX file for the reference so that you can understand and view the formulas that I’ve worked out. Also I’m providing a link below which was created by one of our expert member @Greg pertaining to the topic about “How To Fix The Incorrect Totals”.

Hoping you find this useful and meets your requirements that you’ve been looking for. :slightly_smiling_face:

Thanks and Warm Regards,
Harsh

Expats - Harsh.pbix (38.7 KB)

4

Thanks Harsh, Perfect solution, just what I was looking for.
Learnt a few new things here.
Much appreciated. :grinning:

5

Hello @chris786,

You’re Welcome. :slightly_smiling_face:

I’m glad that I was able to assist you and you found it helpful.

Thanks and Warm Regards,
Harsh