sum of max-min per category

[Anonymous]

Hi, 

I would to get the difference between max value and min value per category. And sum those differences later.

Should i use somekind of sumX?

[parry2k]

@Anonymous not sure how your data looks like but something like this will work, add new measure as shown below

drop category and following measure in table visual and you will have the result

Difference Min and Max = 
MAX( Table[Value] ) - MIN( Table[Value] )

[Anonymous]

Tnx for your reply @parry2k , but what if want to have the sum of the differences in a card visuals and this changes with filters like date etc..

example:

a 2

a 1

b 3

b 10

Normal max-min  = 10-1 =9

per cat : a = 2-1 =1

              b = 10-3 =7

Sum a +b = 8 -----> this is what i need i a card visual

[parry2k · Accepted solution]

@Anonymous add this measure to sum up min/max difference

Min Max Total = SUMX( VALUES( Table1[Type] ), [Min Max Diff] )

[Anonymous]

@parry2k It does not show the correct answer unfortunately

[parry2k]

@Anonymous solution attached, not sure why it is not working for you

[Anonymous]

@parry2k 
I tried to put everyting in one measure and it does not work:

Min Max Total 2 = var MinMaxDiff = MAX(Table1[Value])-MIN(Table1[Value])

return

SUMX(VALUES(Table1[Type]);MinMaxDiff)

But if a tried what you described:

Min Max Diff = MAX( Table1[Value] ) - MIN( Table1[Value])

Min Max Total = SUMX( VALUES( Table1[Type] ); [Min Max Diff] )

then i works. Not sure why the var method does not work.

Grateful if you could explain it to me!