Sum of Max Values in PowerBI

- - - - My Courses - - - -
✔️ Mastering DAX in Power BI -

✔️ Power Query Course-

✔️ Master Excel Step by Step-

✔️ Business Intelligence Dashboards-
- - - - Blog & Download File - - - -

---
► Artist Attribution
Music By: "After The Fall"
Track Name: "Tears Of Gaia"
Published by: Chill Out Records
Official After The Fall YouTube Channel Below
License: Creative Commons Attribution-ShareAlike 4.0 International (CC BY-SA 4.0)

[carlosgomez-dfcg]

simply.. wonderful. I had days stuck in a similar problem. thank you so much..

[daveboylan]

sum the max's of a sum. fascinating

[aagachirandha]

It's my longtime requirement to get subtotal for conditional measure, finally I got it... Thanks a lot

[ajieapen]

Chandeep, this one is a lot similar to the one you uploaded on May 4 (Sum of Visible Values). In the previous one, context transition was needed for the output of the ADDCOLUMNS function to be correct. In this solution, a context transition was not needed. I guess it is because, DISTINCTCOUNT (which you used in the previous solution) is an aggregator and MAXX (the one you used here) is an iterator. Pls correct me if I am wrong... I am just a beginner and trying to understand how these things work... :)

[wayneedmondson]

Awesome Chandeep! Thanks for sharing your DAX magic :)) Thumbs up!!

[mauryavijai]

Thanks for the detailed description. This is very helpful in one of my use case

[sahiladya]

Can we find minimum value out of all the max values at year and month level and apply conditional formatting?

[yasinacar]

crayz 👍
What if I would like see only the month which is maximum sales?

[kenleong]

Thanks. Btw, what's your numbering format? why is there a comma for 100 thousandth position?

[shashipaul]

Thanks for this video .... there is another issue which I am facing where I am having columns: Policies, Classes of polices and each class can have different versions and those versions can have further contribution of premium which can be like 100% or split into 2 or 3 percentage amounts. We need the maximum version only. Tried it through MAXX however didn't work. .. Any Suggestion would be really appreciable.

[vishnurao]

Which shortcut key do you use to format the DAX?

[leahguevara]

Hi. I'm very new to power bi and writing formulas. Ur videos rvvery helpful. Tell me, how do I write a formula to say, "if, there is more than 1 unique invoice amount, then sum the value, if not, give max value. HELP

[abhisheka]

Hi chandeep i have a question kindly reply me if possible
i want to calculate monthname of highest sales .
while i'm clicking on year slicer i should be able to fetch the month name for that particular year with highest sales .i have tried alot but unable to solve this

[williamarthur]

I'm going to have to re - watch that one, have you any ideas for finding the Nth largest / smallest value, ( excel LARGE, p query List.FirstN(list, x, ){nth } ), I've tried,
MIN( TOPN( X, Table, Table [Unit] ) ), but this doesn't work any suggestions?

[bahlatbilal]

Just curious why you didn't use summarize columns instead of combining add columns and summarize

[pedrochaves]

It´s a nice solution, but it could be slow if we have to summarize a large table and apply a MAXX formula that changes dynamically. In my case, it would be slow because the summarize has to calculate the MAXX formula to every single row and than apply my page filters, so it spend time calculating several rows to only see about 0.5% of the data. Is there a way to change the steps orders, so it would apply the page filters first and then summarize?

[lamourpaspourmoi]

omg! Thank you! Just helped me to solve a problem

[RiaJain-ydrk]

how can you modify this if you are using 12 columns

[nishantkumar]

That's cool. Thank you very much.

[sukhomoyb]

Would have been great if you would show the Winning Product as well along with the Total Sales.