Summary Table Custom Total

[ak77]

I have  a summary table as below and  % Complete Column total to be displayed as the total of another Sum of % Complete column. in short.. can we have another new measure/column New  % Complete as below where all  values are from  % Complete and total from Sum of % Complete columns

[Uzi2019]

Hi @ak77 

How you'd calculate Sum of % complete??

[Jihwan_Kim · Accepted solution]

Hi, 

If both [% Complete] and [Sum of % Complete] are MEASURES (not columns), and then please try something like below whether it works.

New % Complete =
IF (
    HASONEVALUE ( 'TableName'[Title] ),
    FORMAT ( [% Complete], "#,#0.00%" ),
    FORMAT ( [Sum of % Complete], "#,#0.00" )
)

[ak77]

Thanks for repliies all. 

@Jihwan_Kim , ur solution with a bit of tweak worked for me.. Thanks