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 how your tables are connected? Seems like you have to remove filter from product category. To simply test it, put a table visual, add sales person and product category and rank measure in it and see if your rank is showing expected result, if not that is your problem and need to be fixed.
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.