Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

RANX with two tables

Hi there,  My first post here, so I'm nervous :) I have two tables: User IDs have a relationship in the model.  I created a simple visual using two measures:  1. Total values: SUM('FACT TAB...
Need Help
mussaenda's avatar
mussaenda
Icon for Community Champion rankCommunity Champion
7 years ago

Try putting the usrname on your fact table.

and use that username to your visual.

Did it rank correctly?

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    mussaenda thanks for your prompt reply. Yes, I could do it but I'm not 100% sure if this is the right approach as user name is not the only one reference data being used in this case. For example, I would like to add "country" to the visual and I'd have to add this column to the fact table as well. 

    This would, in effect, turn my fact table into fact+ref table which is not super elegant. I mean I could but this would turn my fact tables into unmanagable monsters :) 

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      So I tested it by adding a new column in the fact table like this: 

      User name = RELATED('REF Table'[user name])

      but to no avail, the rank gets corrupted. 

    • mussaenda's avatar
      mussaenda
      Icon for Community Champion rankCommunity Champion
      7 years ago

      Okay, I get you.

      For sure someone else here will share ideas.