Forum Discussion

Mirithu's avatar
Mirithu
Icon for Helper II rankHelper 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:                       Ho...
Need Help
V-lianl-msft's avatar
V-lianl-msft
Icon for Community Support rankCommunity 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
    Icon for Helper II rankHelper 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.