Forum Discussion
Solved
Summary Table Custom Total
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
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" ) )
3 Replies
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" ) )
