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

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

    Hi Anonymous

     

    Thanks for reply. Really appreciate.

    I am using dax measures for the calculation.

    And most importantly, measure needs to show first, then only break down by franchise and non franchise.

     

    Seemed like there is no easier way but to design it in normalized form...