Forum Discussion
How to rank two fields using rankx
I am trying to create a visual like this. I am unable to rank transaction count and amount at the same time. When users input how many top N entries they want to see, the count and amount sho...
Mahesh0016
Super User
Super Userhi Pranali_R can you eaxplain about entries in slicer you use.
I am using the Top N Dynamic What if Parameter approach to rank and filter the entries.
But using this.. I am able to just filter on one attribute ..either transaction count or transaction amount.
Number of entries =
VAR SelectedTop = SELECTEDVALUE('TopN'[TopN ])
RETURN
SWITCH(TRUE(),
RANKX (
ALLSELECTED( Query[CPO NAME] ),
[Count]
)
<= SelectedTop,[Count]
)