Forum Discussion

Mirithu's avatar
Mirithu
Helper II
6 years ago

Insert calculated row in a matrix

Hi,

I have a matrix table in Power BI that looks like this:

 

 

 

 

 

 

 

 

 

I would like to insert a calculated row as highlighted below:

 

 

 

 

 

 

 

 

 

 

 

How would I go about doing this?

 

Kind regards.

 

 

 

 

 

 

 

 

 

Need Help

2 Replies

  • V-lianl-msft's avatar
    V-lianl-msft
    Community Support
    6 years ago
    Hi Mirithu ,
     
    You can use the if function and corresponding filter conditions to create a new calculated column, and then add it to the hierarchy. In addition, your value needs to create a measure instead.
     
    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
    • Mirithu's avatar
      Mirithu
      Helper II
      6 years ago

      Hi Liang,

       

      Thank you for replying. 

      I do not understand why I would need to use an IF function yet I am not evaluating a condition.

      I just need to get the percentage of a value from a total in the same column.

       

      For example, if I was doing this in excel, the formula would be, say, =A3/A5*100, then I would apply this across the row.

       

      Kind regards.