Forum Discussion

jaryszek's avatar
jaryszek
Icon for Super User rankSuper User
5 months ago
Solved

DrillThrough filter direction

Hello, Testing drillthrough behavior in Power BI and wanted to confirm something with the community 👇 Setup: Source page → visual built on fact table (Fct_EA_AmortizedCosts_Daily) Target...
Need Help
  • johnt75's avatar
    johnt75
    5 months ago

    The filter direction is treated the same on drill through pages as on any other page, what is happening here is to do with expanded tables ( https://www.sqlbi.com/articles/expanded-tables-in-dax/ ). 

    If you have measures on the drill through page which use the fact table as a filter argument that would explain what you're seeing. The drill through filter is applied to the expanded fact table which includes all the columns of the dimension table, so only the relevant rows of the dimension table are visible.

johnt75's avatar
johnt75
Icon for Super User rankSuper User
5 months ago

The filter direction is treated the same on drill through pages as on any other page, what is happening here is to do with expanded tables ( https://www.sqlbi.com/articles/expanded-tables-in-dax/ ). 

If you have measures on the drill through page which use the fact table as a filter argument that would explain what you're seeing. The drill through filter is applied to the expanded fact table which includes all the columns of the dimension table, so only the relevant rows of the dimension table are visible.