How to add "% of Total" row at the bottom of the table?

[Anjunadeep]

Hello everyone, 

I have this table currently built on powerbi,

The values are Balances

I want to add a % of Total row at the bottom for each column. The formula would look like this :

3,194,443 / 7,828,577

2,246,932 / 7,828,577

This formula should report until last total for column 181+. 

Any suggestions? Thanks in advance for your help! 

[V-lianl-msft · Accepted solution]

Hi @Anjunadeep ,

Please try to create a measure like below:

Total2 =
IF(ISBLANK(MAX('Table'[id]))=FALSE(),
IF(COUNT('Table'[id])=COUNTX(FILTER(ALL('Table'),'Table'[group]=MAX('Table'[group])),'Table'[id]),
FORMAT(DIVIDE(SUM('Table'[value]),CALCULATE(SUM('Table'[value]),ALL('Table'))),"Percent"),
SUM('Table'[value])))

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anjunadeep , I doubt you can add an additional row , but you can change grand total using isinscope or

hasonevalue

if( isinscope([Row Column]) , [Measure], divide([Measure], calculate([Measure], allselected())) )

https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/

https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/