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.
Hello parry2k ,
You are correct. The table doesn't yield what I need and product categories mess up my RankAll formula.
I created another Rank formula which "holds", meaning it will always give the same rank to an individual, even on a table showing product categories.
TEST =
CALCULATE (
RANKX (
ALLNOBLANKROW ( Reps[INDUSTRY REP] ),
[KPI_4]
),
ALLSELECTED ( Machine[PRODUCT FAMILY] )
)However it still doesn't work when I use it as a filter in the custom visual and seems broken. Filtering on "TEST is 2" for exemple, the visual displays nothing at all.
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.