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.

amitchandak's avatar
amitchandak
Super User
4 years ago

Dunner2020 , I do not see the join between qualifications and Authorisation(Dimensions are fine. They do not join) , so that means cross join behavior.  You need have join of handle that in meausre