Forum Discussion

erniemon's avatar
erniemon
New Member
5 years ago

RANKX, virtual table, Filter on visual

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

 

Need Help

2 Replies

  • selimovd's avatar
    selimovd
    Most Valuable Professional
    5 years ago

    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
     
    • erniemon's avatar
      erniemon
      New Member
      5 years ago

      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.