Forum Discussion
RenanPNog
Helper I
Helper IProblem on trying to show 0 when BLANK
Hello everyone! So, i'm having a tough time on trying to display 0 when my measure results in BLANK. I'm also attatching the powerBI file here so you guys can fully comprehend what i'm seeking......
ajohnso2
Solution Supplier
Solution SupplierI looked at your model and didnt change anything in your calc.
This is what you were intending? I did actually change the aggregation for your ID columns - you may want to take care of that, change from Sum to Dont summarise for all ID's (pretty sure this is the issue with your product filtering. You are filtering the sum of product id = 3 rather than the distinct values of product id = 3)
Result when fixed aggregation:
ajohnso2Solution Supplier
Solution SupplierIt looks like you changed your aggregations on the visual only??
See below:
Please ensure you spend more time checking your model is correctly 'modelled' before moving onto reporting. I.e setting/checking datatypes, integer ID's should never be set as sum.
Andy