Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I am intermediate with DAX and have a problem.
I have a complex Measure in a Card visual and I want to enable drill-through to a details page.
I used this article to enable drillthrough on the card visual -
https://xxlbi.com/blog/card-drill-through-power-bi/
This article does describe the problem I am having but discusses a very complex solution that would probably not scale to alot of measures -
https://blog.crossjoin.co.uk/2018/12/21/power-bi-drillthrough-complex-measures/
Another post that discusses this issue -
Since this was written in 2018-2019, has there been any additional features that would make solving this problem easier?
Once again, I am not great with DAX, but is there a way to easily access the filter context of a measure and apply it to a table in a dynamic way (a way that doesn't requires creating duplicate measures for every drill-down filter)? Help!
Solved! Go to Solution.
Nothing has changed in DAX in this regard.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingI think there is no way.
But you can put the filters of the DAX measure in the panel filter of the page you use to drill down. If your measurements aren't too complex, it will work. Although it forces you to have a page for the detail of each measure.
Nothing has changed in DAX in this regard.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingThank you for the reply. With the introduction of Card visual drill-down in Sept 2020, I had hoped this would've changed. I will try the way described above for individual measures.
For anyone with ears inside Microsoft - this is needed for an elegant drill-down experience! This is also a problem in Power Pivot based Pivot Tables. Pivot Tables have had implicit measure drill-down for many years, but no explicit measure drill-down, you have carried this problem over to Power BI via SSAS and Tabular Model technology, how do you expect broad adoption of DAX and measures without native ability to apply measure filter context in drill-down?
Users describe this problem all the time, but don't know how to express it on your ideas page. When I see an explicit measure as KPI in a card visual, I want to drill-down and what makes up that number, so do your users!
I can also see an approach in doing this in Power Query (sum/count with IF as custom column) but that would make my models huge or in DAX as calculated columns (SWITCH). But I would have to create a calculated column for each implicit measure to count/sum criteria and would restrict me in doing what are essentially very simple implicit measures in the model. But the common wisdom I have seen is to avoid complex calculated columns and use measures. Very confusing advice, this topic, and a conflicting message.
User | Count |
---|---|
54 | |
22 | |
19 | |
16 | |
11 |
User | Count |
---|---|
81 | |
55 | |
39 | |
20 | |
12 |