Drilldown/not showing correct values

[Prarav]

Hello,I am quite new to Power BI and I am encountering the following issues:

I have four tables (A, B, C, and D) that are related as shown in the screenshot below. I need a chart to display the count of signed documents by the main office. Additionally, when drilling down into a main office, the chart should show the count of signed documents by each sub-office.

My issue is that the bar chart displays the correct count of signed documents by the main office (e.g., main office MD shows a count of 100 signed documents). However, when I drill down to view the counts by sub-office, it shows the same value for all sub-offices (e.g., md1: 100, md2: 100, md3: 100). The counts are not displaying correctly for the sub-offices. How do I resolve this issue?

[v-cgao-msft]

Hi @Prarav ,

Looking at the relationship, TableD's filter can't filter TableB. If the amount of data is small, try changing the direction of the cross-filter between TableC and TableD to both.

Bidirectional cross-filtering in Power BI Desktop - Power BI | Microsoft Learn

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group

[Prarav]

I tried changing the direction of the cross-filter between TableC and TableD but still not working.