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 TAB...
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 :)
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.