Forum Discussion

satubuku83's avatar
satubuku83
Frequent Visitor
8 years ago
Solved

Multiple measures as hierarchy in matrix

Hi All,   I am new (1 month exp) in using Power BI. I am having some difficulties in designing the matrix in Power BI. Would greatly appreciate if you could share any solutions to it.   Design of...
  • Anonymous's avatar
    Anonymous
    8 years ago

    satubuku83,

    Do you create calculated measures called Earned Premium,Earned Count, Average Earned Premium in your table? Or do you have built-in fields(or calculated columns) called Earned Premium,Earned Count, Average Earned Premium in the table?

    If you the mentioned fields are calculated measures, you would need to create a disconnected table as described in this similar blog. If the mentioned fields are built-in, you can create a Matrix visual and drill down it using the highlighted button as shown in the following screenshot.





    Regards,
    Lydia

satubuku83's avatar
satubuku83
Frequent Visitor
8 years ago

Anonymous , Many thanks for the solution.

I took quite a long time to understand it. Interesting way instead of denormalizing.

Appreciate the advice!