Forum Discussion
Filter a RANKX result on a specific visual
Ok so I solved it.
I can't pass the rankx formula in the filter fields, as it breaks. I couldn't also use it to generate a new DAX table, because I have report-wide filters, and it would not capture them.
So what I did was, create 3 measures that yields the name of Sales individual 1,2 and 3 each. Then pass the Sales individual name as filter on visual, select TOP n of this measure. Works perfectly.
Not pretty, but I got what I needed.
Stemar_Aubert IN which visual it is not working? How you are filtering it? Can you share that info please?
I am using this custom visual :
https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104381018?tab=Overview
Filtering by Sales Representative Name works
Using the TEST measure doesn't work.
As you can see, if I filter using the Sales rep name, it works (data is scrolling correctly).
But when I use the TEST measure to filter, it doesn't give anything.
Thanks !
Ok so I solved it.
I can't pass the rankx formula in the filter fields, as it breaks. I couldn't also use it to generate a new DAX table, because I have report-wide filters, and it would not capture them.
So what I did was, create 3 measures that yields the name of Sales individual 1,2 and 3 each. Then pass the Sales individual name as filter on visual, select TOP n of this measure. Works perfectly.
Not pretty, but I got what I needed.