Forum Discussion
Including Measure Filters from Column Context with Drill-through
I have a matrix that is using say, Account Names (a table column) as the Rows, and multiple measures that are all different summed-up filterings of the revenue in related revenue line items as the Values; say, filtered by year, by the market, etc. There is nothing in the Column field.
I am trying to create a drill-through function to show the individual line items for each measure, by selecting a measure value and automatically displaying the items filtered by both Account and the Year/Market/etc. However, the drill-through only carries the row context (Account) to filter the resulting page, and the DAX filters done in the measures do not get applied.
I could get the effect I want by changing from using measures by moving the filters to the columns field of the matrix, but the matrix contains information that doesn't want to get filtered (like people assigned to the account, static values unique to each account that need to be displayed, etc), so that's not an option.
Is there any way to get the filters from a measure to be applied during a drill-through? I can also do a workaround with multiple drill-through destinations with preset filters, but I'm not able to find a method to determine which measure/value is being selected.
Hi A_Yao
Without seeing your PBIX file and an example of the desired outcome, it’s very hard to give a precise answer to questions like this.
In general, drill-through only carries the filters from the cell context (rows, columns, slicers), not the internal filters defined inside a measure. That’s why the filters you’ve built into the DAX measure are not applied when drilling through.
If you want to alter that behavior, you’ll need workarounds (for example, restructuring the model or using supporting tables). This video shows one such approach:
https://www.youtube.com/watch?v=BG51W2lKYIAIf you mean something different, the best way forward is to share a stripped-down PBIX without sensitive data and show the expected result. That will make it possible to propose a more targeted solution.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
3 Replies
- Ritaf1983
Super User
Hi A_Yao
Without seeing your PBIX file and an example of the desired outcome, it’s very hard to give a precise answer to questions like this.
In general, drill-through only carries the filters from the cell context (rows, columns, slicers), not the internal filters defined inside a measure. That’s why the filters you’ve built into the DAX measure are not applied when drilling through.
If you want to alter that behavior, you’ll need workarounds (for example, restructuring the model or using supporting tables). This video shows one such approach:
https://www.youtube.com/watch?v=BG51W2lKYIAIf you mean something different, the best way forward is to share a stripped-down PBIX without sensitive data and show the expected result. That will make it possible to propose a more targeted solution.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
- v-aatheeque
Community Support
- v-aatheeque
Community Support
Hi A_Yao
Have you had a chance to look through the responses shared earlier? If anything is still unclear, we’ll be happy to provide additional support.