Creating Dynamic subtotal in column matrix

[Vinothsusai]

Hi,

I am new in power bi. I already created a Matrix table in that i need to create a sub total measure based on the Formula.Could you please advise.

Thanks

Vinoth SUSAINATHAN

[v-lili6-msft · Accepted solution]

HI, @Vinothsusai 

Here is a similar post for you refer to:

https://community.powerbi.com/t5/Desktop/Calculate-formula-column-based-on-Id-referred-column-Non/m-...

For your case, Just create a similar measure onstead of drag [P&L Amount] to Values directly.

Best Regards,

Lin