Forum Discussion
RANKX Assigning Duplicate Values
I am having trouble using the RANKX function. I have two tables. One is a table with inventory values that contains the measure INV $ (The measure is just a sum of the inventory $ column). The other ...
For those having this issue I was able to solve it with the below formula:
[Rank] :=
IF (
HASONEVALUE ( 'Dim Item'[Family] ),
RANKX(ALLSELECTED('Dim Item'[Family]), [INV $],,DESC,Dense)
)
I have no clue why IF HASONEVALUE made the difference however, I've posted the question to the original site:
https://www.sqlbi.com/articles/use-of-rankx-in-power-bi-measures/