Show value as percentage of sub column value

[amirghaderi]

Is there any way in the below example to set Power Bi to calculate each row % from total highlighted in yellow (Total of baseline) and (Total of Current) and not the full line total.

It means that there will be 100% for current and 100% for Baseline

[v-shex-msft]

Hi @amirghaderi,

I think you can add if statement to check the current content level and write specific DAX expression for the subtotal level calculations:

Clever Hierarchy Handling in DAX - SQLBI

If you are confused about the coding formula, please share some dummy data to test.

How to Get Your Question Answered Quickly

Regards,

Xiaoxin Sheng

[Fsciencetech]

Please share sample pbix