Insert calculated row in a matrix

[Mirithu]

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.

[V-lianl-msft]

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]

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.