Convert measure to table in DAX

[Anonymous]

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:

Name	Level	Status
Extract 2D plans	APS	High
Extract 2D plans	EXE	Medium
Extract 2D plans	LIV	Low
Other Function	APS	Medium
Other Function	EXE	Low
Other Function	LIV	High

And what I want is as follows:

Name	APS	EXE	LIV
Extract 2D plans	High	Medium	Low
Other Function	Medium	Low	High

Thanks in advance.

[Anonymous]

How to Get Your Question Answered Quickly - Microsoft Power BI Community