how to get a max of a measure?

[Anonymous]

I have this data:

(last column shall be a sum grouped by BU and UP).

I have achieved the last column SubTotalBU, by doing:

SubTotalBU = CALCULATE ( sum(Sheet1[NSR]), ALLSELECTED(), VALUES(Sheet1[BU]),  VALUES(Sheet1[UP]) )

My goal is to get the max of column SubTotalBU for each UP… That is; I need a column  with all values 90 in this case.

I have tried using MAX of SubTotalBU, but it doesn’t work with measures… How can I get it?

[Anonymous]

doesn't work (last column below...). I aim to get the max (that is, 90 in every row...)

[V-lianl-msft · Accepted solution]

Hi @Anonymous ,

Please try to create a measure like below:

Measure = MAXX(ALL(Sheet1),[SubTotalBU])

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , Try a measure like

maxx(addcolumns(summarize(Sheet1, Sheet1[BU],Sheet1[UP]),"_1", calculate(sum(Sheet1[NSR]),filter(allselected(Sheet1),Sheet1[BU] =max(Sheet1[BU]) && Sheet1[UP] =max(Sheet1[UP])))), [_1])