Left join to show all of my left table

[vbourbeau]

Hi,

How can I do a left join.

Here I have invoice and line for invoice. When I add a sum measure I lost the invoice 5,6,7. I want to keep it with null value or 0.

Thanks

[VasTg]

@vbourbeau 

Try this.

IF(SUM(PRICE)>0,SUM(PRICE),0)

If it helps, mark it as a solution

Kudos are nice too 

[amitchandak · Accepted solution]

Try show item without data

[vbourbeau]

too easy

Thank you 🙂