showing total but not the value in visual when values cant be matched

[HBL_Nick]

Hey guys,

I have 2 tables who have a relation on the columns ordernr and invoicenr

When there is a match, the visual is doing fine:

But as soon as there is no match for a given ordernr, the value in the row is going blank but the total is still there. How can I show the quantity (which must be 6 in both rows).

I hope u guys can help me out 🙂

Thanks!

[HBL_Nick · Accepted solution]

Thanks for the suggestions guys, recreating the relationship between te tables in the model solved the solution for me.

[Ashish_Mathur]

Hi,

Not sure what you want but try this.  Use the Query Editor to append both tables and then build your visual from the appended table.

[ryan_mayu]

@HBL_Nick 

maybe you can try this

Measure = if(ISBLANK(sum('Table'[QTY])),sum(Table1[QTY]),sum('Table'[Qty]))