Forum Discussion

epelton's avatar
epelton
Icon for Helper I rankHelper I
3 years ago

Measures with shared headers

I am attempting to do the exact same thing as this post, but getting strange results.   Solved: Shared header for measures in a matrix - Microsoft Power BI Community   I would like to display my ...
Need Help
epelton's avatar
epelton
Icon for Helper I rankHelper I
3 years ago

Thanks Gao. This does display the headers correctly, however, the client does not consider this to be a solution, as they drill up and down while using the report and want both headers displayed regardless.

bolfri's avatar
bolfri
Icon for Solution Sage rankSolution Sage
3 years ago

 

 

Measure = 
SWITCH(TRUE(),
    SELECTEDVALUE(GUI_Headers[Header_lvl1])="Total" && SELECTEDVALUE(GUI_Headers[Header_lvl2]) = "Sum header", [Sum],
    SELECTEDVALUE(GUI_Headers[Header_lvl1])="Total" && SELECTEDVALUE(GUI_Headers[Header_lvl2]) = "Avg header", [Avg],
    SELECTEDVALUE(GUI_Headers[Header_lvl1])="Last day" && SELECTEDVALUE(GUI_Headers[Header_lvl2]) = "Sum LD header", [Sum LD],
    SELECTEDVALUE(GUI_Headers[Header_lvl1])="Last day" && SELECTEDVALUE(GUI_Headers[Header_lvl2]) = "Avg LD header", [Avg LD]
)

 

Works for me. You can still drill down Region > City. 🙂