Forum Discussion
RANKX(ALL SELECTED… DAX causing duplicates
Here is my DAX expression: $ RANK = RANKX(ALLSELECTED('Store-Level'), CALCULATE(SUM('Store-Level'[$])), ,DESC) This DAX works in my smaller filtered table (right), but I have another larger filt...
ThxAlot
Super User
Super UserALLSELECTED(Table) and ALLSELECTED(Table[Column]) are totally different. There's no point ranking every row of the table by ALLSELECTD(Table).
The actual dataset is about 875,000 rows, but there is a filter on the entire tap that filters out customers down to a specific customer. This filters it down to about 500,000. I am trying to get the ranking column on the 500K rows, but also want it to re-rank based on various filters down to brand, category, etc.