Forum Discussion
Measure + 0 is adding relationship who doesn't exist between objects
I solve my problem using columns at each level, calculating the sum but it less flexible with filters. Mergin rows can't work if you have to many rows, it's also duplicating values.
Thanks for your help
The measure without the +0 returns a blank - which is automatically filtered out of Power BI reports. But when you add 0 to it, the blanks all becomes zeros - which are NOT automatically filtered out of reports...so you'll see rows show up for every combinations of dimension values.
You didn't really specify what the input data tables look like, but I'm imagining:
A "parent" table that has a parent key and parent name
A "child" table that has the child key, child name and a parent key
An "income" table that has child key and income amounts - presumably there are no rows for children who have zero income (because I think they would have shown up if those existed)
If this is the case, then in Power Query you can "merge" rows into the income table that contain each unique child from the child table along with an income amount of 0 (NOT blank). Then I think you measure will show all children and their relationships to parents, without having to use the +0 in your measure (which hoses everythign up)
Hope this helps!
Scott
I solve my problem using columns at each level, calculating the sum but it less flexible with filters. Mergin rows can't work if you have to many rows, it's also duplicating values.
Thanks for your help