Forum Discussion
DAX, Complex Measures, Drillthrough
- 5 years ago
Nothing has changed in DAX in this regard.
Nothing has changed in DAX in this regard.
- jbbcormed5 years agoFrequent Visitor
Thank 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.