Drill down showing all values for non related tables calculations

[danielcontente]

Hi, 

I have several tables in  my data model.

I use this model to create a pivot table, that contains calculations from the several tables.

The pivot table is filtered by a calendar table.

However, when i add a field to the drill down, it shows everything (not only the ones containing a value).

I assume this is happening because i have other calculated fields (using dax) that don't have a relationship with the table that the drill down field belongs to (please see picture below).

Any idea on how to show only the drill down fields containing values and make the non related calculations ignore this field?

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523