Drill through and pull information from related table

[Yodaswhiskers]

Hi, 

I am new to Power BI and I have run into an issue that I can't really resolve and am hoping someone can help. I have 2 related tables linked by "Company Name"

When I drill through by Company Name from Table 1, I would like to pull the respective value from the "Users" column in table 2.

E.g Drill through on company name = AAA

Table 2                

Company Name           Users

AAA                                  5

BBB                                   4

CCC                                   8

DDD                                 12

In the above example it would pull through the value 5

Whilst every field that is in Table 1 on the page filters perfectly, the elements that are from Table 2 are incorrect. Everything I have tried so far (apart from hard coding the company name which I need to be dynamic from the drill through) brings the sum of all users back and not the value specific to the Company Name selected during the drill through.

Any help would be greatly appreciated.

Thanks in advance

[v-cherch-msft · Accepted solution]

Hi @Yodaswhiskers

You may set the relationship like below.Please check the cross filter direction is single( from table1 to table2) or Both.

Regards,

Cherie

[Yodaswhiskers]

Thank you very much Cherie, your help was greatly appreciated and worked perfectly!