Help with dax measure

[Anonymous]

Hi, I really apreciate if any one can help me with this problem

ID School	Level	Service	Qty
101	primary school	Lunch	20
101	primary school	Breakfast	18
101	primary school	snacks	7
101	high school	Lunch	30
101	high school	Breakfast	40
602	primary school	Lunch	10
602	primary school	Breakfast	21
602	high school	Lunch	25
602	high school	Breakfast	15

Max qty by service in
ID 101
for primary school is 20,
For high shcool is 40 
in ID 602 
for primary school is 21,
For high shcool is 25

Expected measure result is 20+40+21+25 =106 

[Applicable88 · Accepted solution]

@Anonymous , as I understood the ID school and schoollevel belonging together, so you can summarize them. Please take a look at Measure:

Measure = sumx( ADDCOLUMNS(SUMMARIZE(Tabelle1,Tabelle1[ID School],Tabelle1[Level]),"Total", calculate(MAX(Tabelle1[Qty]))),[Total])

Hope it helps.

Best regard. 

[Natallia_23 · Accepted solution]

Hello,

Max = CALCULATE(MAX(Table1[Qty]),ALLEXCEPT(Table1,Table1[ID],Table1[School Level]))

Result =

var x = SUMMARIZECOLUMNS(Table1[ID],Table1[School Level], "res", [Max] )

return sumx(x, [res])

[Applicable88 · Accepted solution]

@Anonymous , as I understood the ID school and schoollevel belonging together, so you can summarize them. Please take a look at Measure:

Measure = sumx( ADDCOLUMNS(SUMMARIZE(Tabelle1,Tabelle1[ID School],Tabelle1[Level]),"Total", calculate(MAX(Tabelle1[Qty]))),[Total])

Hope it helps.

Best regard. 

[Anonymous]

Thanks a lot!! works excelent!