Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Subsetting a table based on other table

Hi, newbie here. I've been trying and researching how to do this all weekend, but nothing worked for me yet. Any help would be appreciated. Basically, I have two tables: The first one is called "...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    I did it!! I just used the FILTER function like "NewTable = FILTER('competition', 'competition'[id_competition] = RELATED('winners'[id_competition]) && 'competition'[id_competitor] = RELATED('winners'[id_competitor]))"

    Thanks again for the help!

PaulDBrown's avatar
PaulDBrown
Community Champion
5 years ago

Anonymous 

You can create a virtual relationship using TREATAS (see my edited post above) to filter unrelated fields. Can you show the model view of the relevant tables (both dimension and fact tables)?

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

I did it!! I just used the FILTER function like "NewTable = FILTER('competition', 'competition'[id_competition] = RELATED('winners'[id_competition]) && 'competition'[id_competitor] = RELATED('winners'[id_competitor]))"

Thanks again for the help!