Replacing the Total Figure in Waterfall Charts

[Anonymous]

Hi Folks,

I am looking for a way to replace the automatic total with a number I want on the Waterfall chart. Any suggestions on how to do this?

Thanks

[Anonymous · Accepted solution]

Hi @Anonymous ,

You could take a look at ISINSCOPE() function.

https://docs.microsoft.com/en-us/dax/isinscope-function-dax .

It will return "false" at total field and you could use it with IF() function.

IF(ISINSCOPE(), result_when_true, result_when_false)

Best Regards,

Jay