How to get running total to ignore null values

[Anonymous]

I have built a graph of running totals for different metrics, however for the lines with null values, they are including in the running total and just showing up as straight lines. How would I fix this?

[rafaelmpsantos]

show us the measure created for this values.

[Anonymous]

CALCULATE(
[2016-1 Cash Collections],
FILTER(
ALLSELECTED('Power BI Data'[MOB]),
ISONORAFTER('Power BI Data'[MOB], MAX('Power BI Data'[MOB]), DESC)
)150000

This is my running total metric that i plot

[rafaelmpsantos · Accepted solution]

Try it

IF([2016-1 Cash Collections]=0,"",
CALCULATE(
         [2016-1 Cash Collections],
         FILTER(
               ALLSELECTED('Power BI Data'[MOB]),
               ISONORAFTER(
                          'Power BI Data'[MOB], 
                           MAX('Power BI Data'[MOB]), 
                           DESC)
               )
         )
   )

[Anonymous]

Apologies, I entered the formula in wrong. This is correct thank you!

[rafaelmpsantos]

good to know... If you should please give me a positive feedback ...thanks

[Anonymous]

This did not work

[rafaelmpsantos]

Still showing the line?

[Anonymous]

Yes, the line is still showing