I need to convert this DAX measure
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:
Extract 2D plans
|Extract 2D plans||EXE||Medium|
|Extract 2D plans||LIV||Low|
And what I want is as follows:
|Extract 2D plans||High||Medium||Low|
Thanks in advance.