Forum Discussion

juliausha's avatar
juliausha
Helper I
7 years ago
Solved

Running total for a row avoiding NULL values

Does anyone know how to calculate running total for a row making sure null values are avoided?    My example:    Each row represents amount of shops someone has in the neighbourhood, and co...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    hi, juliausha 

    Please drag "VisitedShops" field from VisitedShops table into Columns Value.

     

    Best Regards,

    Lin

     

     

     

juliausha's avatar
juliausha
Helper I
7 years ago

Thank you for you reply v-lili6-msft ! 

 

I was tryng to follow your suggestions. I used your formula and created a column called 'Value' but for some reason it only gives '1' as a value. So at the end my result in 'Measure' is not matching yours... Could you please take a look at my pbix file? 

 

Here's the link to pbix file in Dropbox: Mydata.pbix

Or WeTransfer link: Mydata.pbix

 

Thanks a lot!

v-lili6-msft's avatar
v-lili6-msft
Community Support
7 years ago

hi, juliausha 

Please drag "VisitedShops" field from VisitedShops table into Columns Value.

 

Best Regards,

Lin

 

 

 

  • juliausha's avatar
    juliausha
    Helper I
    7 years ago

    Ah, great, it works now! Thanks so much v-lili6-msft !

  • juliausha's avatar
    juliausha
    Helper I
    7 years ago

    Ah, great, it works now! Thanks so much v-lili6-msft !