Forum Discussion
Solved
Displaying data resulting from OUTER JOIN
I created a semantic model with a relationship between two tables: Sales sale_id product_id amount 1 1 3 2 1 4 3 2 5 Products product_id name 1 apple 2 ba...
Hello HeinSwift
Please give it a try.
Use the Productsname column in your visual, not from Sales.
Right-click the field and pick “Show items with no data”.
create a measure like thisTotal Amount = COALESCE(SUM(Sales[amount]), 0)
for reference check this video:https://m.youtube.com/watch?v=nTiAaY7waMU
Please accept the answer if this is helpful.Thanks
Hello HeinSwift
Please give it a try.
Use the Productsname column in your visual, not from Sales.
Right-click the field and pick “Show items with no data”.
create a measure like this
Total Amount = COALESCE(SUM(Sales[amount]), 0)
for reference check this video:
https://m.youtube.com/watch?v=nTiAaY7waMU
Please accept the answer if this is helpful.
Thanks
Yes that's it! Thank you very much!