Convert measure to table in DAX

Anonymous — Thu, 22 Jul 2021 07:36:08 GMT

Hi all

I need to convert this DAX measure

Measure =

CALCULATE(

MAX('Table 1'[Status]),

FILTER('Table 1','Table 1'[Level]=MAX('Table 1'[Level]))

)

into a new table. I tried with CALCULATETABLE and MAXX but it does not work.

The data I have is as follows:

Table 1:

And what I want is as follows:

Thanks in advance.

Re: Convert measure to table in DAX

Anonymous — Wed, 21 Jul 2021 17:34:14 GMT