topic Re: sum of max values when selcting multiple slicer values in DAX Commands and Tips

sum of max values when selcting multiple slicer values

Anonymous — Wed, 30 Sep 2020 09:06:42 GMT

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

Re: sum of max values when selcting multiple slicer values

Anonymous — Wed, 30 Sep 2020 09:07:26 GMT

Pragati11

this is the sampe data

Re: sum of max values when selcting multiple slicer values

Pragati11 — Wed, 30 Sep 2020 09:09:04 GMT

Hi Anonymous ,

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

Re: sum of max values when selcting multiple slicer values

Anonymous — Wed, 30 Sep 2020 09:10:12 GMT

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

Re: sum of max values when selcting multiple slicer values

Anonymous — Wed, 30 Sep 2020 09:12:06 GMT

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.

Re: sum of max values when selcting multiple slicer values

Pragati11 — Wed, 30 Sep 2020 10:01:22 GMT

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

Re: sum of max values when selcting multiple slicer values

Anonymous — Wed, 30 Sep 2020 10:56:01 GMT

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. 🙂