How can I show all numbers as absolute values but have totals reflect the true total

[Anonymous]

In accounting, some values are assumed to be negative and some clients expect them to be reported as positive numbers. I'd like to show all of the values as positive numbers but show the correct totals.

[vicky_ · Accepted solution]

You can try something like:

Measure = IF(
    HASONEVALUE('Table'[Column for Capital, Capital to Investments etc...])), // i.e this is not a totals column
    ABS([Your exiting calculation here]),
    [Your exiting calculation here])
)

You might need some more involved IF-statements if you need it to work for subtotals too.

[PhilipTreacy · Accepted solution]

Hi @Anonymous 

Download example PBIX file

Apply a Custom Format String to the values (columns).  For example if you use this format string $#,#;$#,#;$0 (just type it into the Format area as shown below, then hit Enter)

Then all negative values will be displayed as positive values, and your totals will still add up properly.

Regards

Phil

[vicky_ · Accepted solution]

You can try something like:

Measure = IF(
    HASONEVALUE('Table'[Column for Capital, Capital to Investments etc...])), // i.e this is not a totals column
    ABS([Your exiting calculation here]),
    [Your exiting calculation here])
)

You might need some more involved IF-statements if you need it to work for subtotals too.