Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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
Solved! Go to Solution.
Try show item without data
Try this.
IF(SUM(PRICE)>0,SUM(PRICE),0)
If it helps, mark it as a solution
Kudos are nice too
Try show item without data
too easy
Thank you 🙂
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
108 | |
107 | |
91 | |
67 |
User | Count |
---|---|
162 | |
133 | |
132 | |
93 | |
91 |