Hi, I have two tables: Table ORGidnameorg123ax456by789cz Table HOLDINGSidunitsvalue1235050078920200 I would like to output a table (or matrix):idnameorgunitsvalue123ax50500456by00789cz20200 The trick of course is to get the id 456 from the ORG table to show even with no values in the holdings table. I've tried a calculated column of SUM(value) + 0 but it is still not showing. I hope that is clear, any help is appreciated.

Hi SiroPW , Create two measures:Measure = IF(ISBLANK(MAX('Table (2)'[units])),0,MAX('Table (2)'[units]))Measure 2 = IF(ISBLANK(MAX('Table (2)'[value])),0,MAX('Table (2)'[value])) Best Regards,LiangIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Show rows with zero value in table (two underlying data tables)

Forum Discussion

Related content

Underlying Error: OnPremiseServiceException

Underlying ErrorOnPremiseServiceException

Formatting Value of Table

#Temp tables defined under a different collation to the underlying warehouse

Underlying Error Privacy...combining of data