Forum Discussion
undefined
i have one column name is owner name and two measures owner_classification,no of mol vessels. how to rank bases on no of mol vessesl?
RANKX(ALL('Table'[owner name]),[no of mol vessels],,DESC ,Dense)
directly taken no of mol vessels as mentions as measure, if it is a column do with an aggreate function as below
RANKX(ALL('Table'[owner name]),CALCULATE(SUM(Table[no of mol vessels])),,DESC ,Dense)
directly taken no of mol vessels as mentions as measure, if it is a column do with an aggreate function as below
RANKX(ALL('Table'[owner name]),CALCULATE(SUM(Table[no of mol vessels])),,DESC ,Dense)
Let me try it and let you know
I tried both the methods but it didn't work. Please tell me any other method to solve this?
Please share sample data and output to share the proper resolution
how i can i share it. it is a big data