RANKX, virtual table, Filter on visual

[erniemon]

I am displaying yop 7 projects in 7 individual visuals, first visual is has a visual filter in [index] = 1. second visual is filtered on this visual [index] = 2 and so on for the seven visuals. index is a RANKX function on a table column. This works great unitl any slicer is applied. To corerct this, I used a measure to calculate RANKX by allselected. The only problem is I can't refernce or use it as variable filtering on this visual. I doens't let me enter any values. I am guessing it's because I don't have a table referencing this value. 

How can I use a variable in Filter on this visual, that references a RANKX dynamically?

RanktopLate works great when it's a column in a table. but when dynamically recreated to account for any slicers, the measure works in a table but doesn't work as a Filter on this visual. Can anybody help?

Thanks

[selimovd]

Hey @erniemon ,

as you already figured out you can use calculated columns as filter, but not measures as they always need a context.

You have to filter the visuals to your projects and then with the measure return the top 7 for each project.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

[erniemon]

Thanks, So I filter first ok, then I RANKX ok, how do I display seven different donuts setting up each one to Filter on the visual using the measure returning the RANKX? When I use the measure in a table it displays the rank perfectly. when I place the measure in the filter on this visual no action. I put the measure on a card, says (Blank)". So After I have sliced the data, how can I display seven individual donuts by RANK. 
I am using three tables, a master projects table with all tasks, and about 20 projects. A summary table linked by project name. Lastly, a Project name table also linked through the project name. 

This display is using a column in a table that has a rank. Using filter on this visual

Each donut has the value 1,2,3,4,5,6,7. displaying the bottom seven projects. When I filter the rank doesn't work. So I created a measure to rank, and it gives me the proper ranking. Only works in a table or matrix. 

How to get the rank information from the measure to Filter on this visual?

Again I want to express my thanks for helping me.