New measure according by Rank(DAX)

[ngct1112]

Hi,

I am struggling on creating a table which I hope I could seek some helps here. I have upload my BI Sample here.

In my simpified model, I have 2 measures:

1,) Price_FX

2.) 

Rank(Measure) = 
RANKX(
    FILTER(
        ALLSELECTED('Table'[ID],'Table'[Supplier]),
        'Table'[ID] = MAX('Table'[ID])),
        [Price_FX(measure)],,ASC)

With my Original Data:

Project	ID	Supplier	Price(measure)
BI-2021	1	D	15.6
BI-2021	1	B	31.2
BI-2021	1	C	62.4
BI-2021	1	A	15.6
BI-2021	2	A	93.6
BI-2021	2	B	46.8
BI-2021	2	C	39

I am hoping I could create a table like the below.

Appreciated if I could help some helps!

[ngct1112]

@amitchandak Thanks for your help again!

[amitchandak · Accepted solution]

@ngct1112 , create a table using generate series

Bucket = generateseries(1,4,1)

measure =

var _tab = addcolumns(summarize('Table','Table'[ID],'Table'[Supplier]), "Rank",[Rank(Measure)], "_1",[[Price_FX(measure)])
return
maxx(filter(_tab, [Rank] = max(bucket[Value])),[_1])

Take max for supplier, or create a measure like above. Use bucket value in column in matrix