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