Forum Discussion
Repleacing blank() with zeros
I have a table with simple SUM measures, but i need to replace blanks with zeros. If I change measure with IF statement , it will remove filter applied to Machine column withou IF with ...
Anonymous Check out this article on how DAX handles blanks. A number plus a blank = that number, but when you divide with a blank, it returns a blank, not a zero.
You can show/hide items with "no data" which is a blank, using the column setting I gave earlier in a screenshot, or you can cause blanks to return as zero using COALESCE as mentioned before. In its simplest form:
Measure = COALESCE([Some Other Measure], 0)That will return 0 if the [Some Other Measure] returns a blank.
edhans here is an example file
https://www.uschovna.cz/zasilka/ZRT6735A7CEI7IE9-93X/
If you add Scraps % measure to table, it will repeat all machines to all machinetypes. What is happend with relationship?
i dont understand why
thank you