Power BI

Needs Votes

Detect drilldown (drill-down) level to support changing measure / title

Vote (134)

Hymie Ho on 12 Oct 2016 04:09:32

I have a bar chart with a custom hierarchy that drills through different groups of people (sales managers, territory managers, etc.). On the same report I have a measure that calculates AVERAGE (Sales). I want that measure to show the average sales for the current hierarchy (by Sales Managers or by Territory Managers). Here is some pseudo-code with a new DAX command YAXISVALUES that shows how I would use this:

Average Display Value =
VAR
Total=
SWITCH(YAXISVALUES () ,
"SM", SUM('Sales'[Sales ($)]) / DISTINCTCOUNT('Sales'[SM]),
"TM", SUM('Sales'[Sales ($)]) / DISTINCTCOUNT('Sales'[TM])
)
RETURN
IF(ISBLANK(Total),0,Total)

See this topic for other use cases: https://community.powerbi.com/t5/Developer/Dyanmically-changing-the-title-based-on-the-drill-down/td-p/33411

Comments (7)

Comments (7)

Kim Lee on 02 Oct 2023 05:36:46

RE: Detect drilldown (drill-down) level to support changing measure / title

Still waiting for this.

Power BI User on 14 Dec 2021 18:20:48

RE: Detect drilldown (drill-down) level to support changing measure / title

Without this labelling on a matrix I can not add levels to the columns because they do not know what they are . The rows provide a row header but this is missing from the column