Fix Bad Measure Totals in Power BI and Power Pivot

[@emilytran84]

Thank you for your video ! You saved my work sir !

[@barttitulaerexcelbart9400]

Thank you Allan, Thanks for all the video's in 2019. I wish you a good and healthy 2020. I will probably not see you in London, but I hope to see you in Amsterdam soon.

[@Computergaga]

My pleasure, thank you Bart. I wish you love, health and happiness also. Yes, I hope to be in Amsterdam. I'm waiting to find out the date.

[@EricaDyson]

Just what I needed! Thanks a lot!

[@Computergaga]

Excellent! Thank you Erica.

[@excelisfun]

Thumbs Up!!!!

[@Computergaga]

Thank you Mike.

[@spilledgraphics]

Amazing tip Mr. Alan! voilà !

[@Computergaga]

You're welcome. Thank you buddy.

[@Bloody_August]

great tutorial

[@Computergaga]

Thank you, Juan.

[@ImranHussain-xv4se]

Thanks

[@Computergaga]

You're welcome, Imran.

[@brianxyz]

Just to be safe it would be wise to use the Divide function in the measure you created in Power BI. I would love if that DAX function was replicated as an Excel function.

[@Computergaga]

Absolutely. I'm not sure why I didn't use that here.