Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Ranking

Hi there,   This is my very first post here in the community, so I hope I'm doing it in the right way 🙂   I need some help with creating a dax formula for the table "Commodity" , that shows the ...
Dangar332's avatar
Dangar332
Icon for Resident Rockstar rankResident Rockstar
2 years ago

hi,  Anonymous 

 

adjust your table name
try below one
result =
var a = SUMMARIZECOLUMNS('physical commodity'[physical commodity],"cont commodity",[contracted commodity])

var b = SELECTCOLUMNS(a,"rankcomparing",[cont commodity])
return 

rankx(b,[rankcomparing],[Contracted Quantity])

 

'physical commodity' -- is your table name so adjust it .

[Contracted Quantity]  -- is your measue

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Dangar332,

 

[contracted commodity] from variable "a", I believe should be "contracted quantity", right?

In the form with "contracted quantity" the formula does not show anything 😞

Thanks