Forum Discussion
bipowerbix
Helper I
Helper ITricky Situation with SUM
Here is the Data I am using: Type Spent Returns Apple 100 Orange 50 200 Banana 25 150 Pear 500 Kiwi If I use ROI = s...
wdx223_Daniel
Community Champion
Community Champion
bipowerbixHi Daniel, The "+0" at the end gives the result for Kiwi. Is there any documentation for the "+0" online?
- wdx223_Daniel
i just learned this from somewhere in internet. but you can read this article.
https://www.sqlbi.com/articles/how-to-return-0-instead-of-blank-in-dax/
- bipowerbix
This works for this case, I noticed that this doesn't work if other fields such as Dynamic Date are joined to the table. I have attached my post here.