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 be...
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" ) )
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" )
)
