Forum Discussion

Dunner2020's avatar
Dunner2020
Post Prodigy
4 years ago
Solved

Linking two dimension tables

Hi there,   I got a dimension table of a personal record (let's called individual), and a qualification information table. I got two dimension tables: Authorisation and Individual qualification. Th...
Need Help
Show and Tell
Tips and Tricks
  • v-jingzhang's avatar
    v-jingzhang
    4 years ago

    Hi Dunner2020 

     

    Modify the cross-filter direction from Single to Both for the relationship between Individual table and IndividualQualification table. This will work. 

     

    And in the table visual, drag the QualificationDescription column from Qualification table instead of individualqualification table, and use TODAY() to replace NOW() function in your measure. This will improve the speed for calculation. 

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

v-jingzhang's avatar
v-jingzhang
Community Support
4 years ago

Hi Dunner2020 

 

Modify the cross-filter direction from Single to Both for the relationship between Individual table and IndividualQualification table. This will work. 

 

And in the table visual, drag the QualificationDescription column from Qualification table instead of individualqualification table, and use TODAY() to replace NOW() function in your measure. This will improve the speed for calculation. 

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.