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
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi epelton ,

Please try expand all down one level in the hierarchy.

Best Regards,
Gao
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

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. 🙂