Forum Discussion
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 TABLE'[values])
2. Rank:
RANKX
(
ALLSELECTED('FACT TABLE'[user_id]),
[Total values],
,
DESC,
Dense
)and it works well: However, when I add username to the visual, the rank gets corrupted:
How could I get to this:
What am I doing wrong?
Many thanks!
4 Replies
- mussaenda
Community Champion
Try putting the usrname on your fact table.
and use that username to your visual.
Did it rank correctly?
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 :)
