Forum Discussion
Helper IProblem on trying to show 0 when BLANK
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:
- RenanPNog
Hi ajohnso2, thanks for the reply!
Unfortunatelly i couldn't replicate with the info that you sent me. Got the file, changed the aggregation columns, inserted the table, removed columns summarizations in the table, inserted measure.... and still got other course_id's 😞Here's my result:
I'll share a new link bellow, the modifications i did based on your recomendations (removing aggregations)
Test.pbix
PS: my tests are at the "Verific Values" tab - ajohnso2
It 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