sum of max values when selcting multiple slicer values

[Anonymous]

Hi,

Below is the data, i have category and value fields. and Month as slicer.

each month has different values and i needd to take only max value of each month.

and here i am taking max value easily.

here the problem is.. when i select multiple months from slicer.

i need sum value of the max.

fo example. Month1 Appls has 15 as max value and in month 2 max value is 35.

when i select both months. i need to show 50 for Apple.

but here it is taking max value of the both months.

need help how to acheive this.

@Pragati11 @amitchandak @Greg_Deckler @mwegener @lbendlin @Fowmy

[Anonymous]

@Pragati11 

this is the sampe data

[Anonymous]

@Pragati11 

if i select mutiple months from slicer,

i need to see for Apple 50 

not like the below. which is just taking max of the month.

[Pragati11 · Accepted solution]

Hi @Anonymous ,

There are already existing threads for this issue:

https://community.powerbi.com/t5/Desktop/sum-of-max-values-by-date-client/td-p/247337

https://community.powerbi.com/t5/Desktop/sum-of-max-values/td-p/46715

I tried the first link's solution and it works:

Thanks,

Pragati

[Anonymous]

@Pragati11 

thanks for your prompt response. this works for me.

Yes, i have gone through the links you gave below earlier.

But in their case they just want to show max values.

However in my case i need to show max values with cummulative sum based on slicer seelction.

All trick and magic lied in Summarize function.

So, i tweaked my DAX now it is working fine. 🙂

[Anonymous]

@Pragati11 

ValueMonthCategory

15	1	Apple
10	1	Apple
9	1	Apple
30	2	Apple
35	2	Apple
40	3	Orange
50	3	Orange
60	3	Orange

[Pragati11]

Hi @Anonymous ,

Can you paste this as a table please rather than a screenshot so that I can copy paste at my end?