Forum Discussion
RANKX not working with Filters on Visual
Hi all, I'm building dashboard and I'd like to display the rank of the brand based on its market share. The data looks like: Category Brand Value C1 B1 10 C1 B2 5 C1 B3 1...
Ashish_Mathur
Super User
Super UserHi,
These measures work
V = SUM(Data[Value])MS = DIVIDE([V],CALCULATE([V],ALL(Data[Brand])))Rank = RANKX(ALL(Data[Brand]),[MS],,DESC)Hope this helps.