Maximum of Sum

[Anonymous]

HI,

I have data in theformat below: 

I want to calculate the sum of errors by reason and find the reason with maximum sum (The data has multiple rows for same error and source). I tried applying SUMMARIZE function but that doesnt seem to be working. Any help is appreciated!

Thanks in Advance!! 🙂

Source  Number	Reason	Count of Errors
1	Null ID	1
1	Null ID	1
1	Invalid ID	1
1	Invalid ID	1
2	Null ID	1
2	Null ID	1
2	Invalid ID	1
2	Invalid ID	1
3	Null ID	1
3	Invalid ID	1
3	Invalid ID	1

[dujos]

Hello anshi1106,

complementing what parry2k said... and helping with screens:

Yes first create a measure for example: Sum Errors = SUM(Data[Count of Errors])

After that go to visual and select a Table view > Reason > and Measure Sum Errors as showed below:

I hope i've helped

[parry2k]

@Anonymous

Try following:

add new measures :

Sum of Errors = SUM( Data[Count of Errors] )

to get top reason , add another measure

Max Reason = TOPN(1, ALL( Data[Reason]), [Sum of Errors], DESC )

Put "Max Reason" measure in card visual and that will do it.

Cheers!

[Anonymous]

Hi Parry2k,

Thanks for the help, but the solution is giving me the reason (Invalid ID) and not the number for the reason (The number of times it occurs in the data). I need number 6 in the card and not Invalid ID. How to get that?

Thanks

[Arentir]

Hi @Anonymous,

Try this

Sum Error = SUM(Table1[Count of Errors])

Add this to your card and in the visual filter, have a Top 1 of Reason based on Sum Error

[parry2k · Accepted solution]

@Anonymous

I thought you need max category, here is to measure to get the numbers

Max Reason 2 = MAXX(  ALL(Data[Reason]) , [Sum of Errors] )