Max value not sum value

[sraj]

Hi,

I am using a matrix visual for this. 

Displaying the date values for 2022 (492,682) & 2021(451,44) with this measure:

Total Count = SUM('Combined Table'[owner_cnt]) + SUM('Combined Table'[Rental_cnt])

Right now if I turn on the ROW subtotals it gives me the total of all the values, but I need to see the MAX COUNT.  Because this is a calculated measure value I don't know how I can show the Max value for the selected month or year.    

Can someone please advise on this?

[sraj · Accepted solution]

Just incase anyone needs it, this helped me on my above question.

MAX VALUE = MAXX('Table',[Total Count])

[Greg_Deckler]

@sraj More or less a measures total problem/MM3TR&R:

This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

Matrix Measure Total Triple Threat Rock & Roll - Microsoft Power BI Community

[sraj]

This is very useful, thanks for sharing!

But my problem with this is not that the total is incorrect, I am trying to show the MAX COUNT value that would be the latest value for the year columns not the total.