Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hi,
I would like to show 0's instead of blanks in a table showing sales and purchases for products. I have created a dummy report to show what issue I am running into.
The dummy report has 3 tables:
I have created to measures:
I created a table with three columns:
Below you will find a screenshot of the outcome:
In the middle table only the products are shown that have a purchase of sales. But for product C, the sales column is blank. Here, I would like to display 0.
I then tried another measure:
The table on the right show the outcome with that column. Now it shows 0's but now all products are shown in the table.
What can I do to only show products that either have sales or purchases with the value 0 instead of a blank?
Regards,
Mark
Solved! Go to Solution.
@markblom Try:
Sum of Sales Zero =
VAR __Result = IF( [Sum of Purchases] = BLANK() && [Sum of Sales] = BLANK(), BLANK(), SUM(Sales[Quantity]) + 0
RETURN
__Result
Also, there is no reason for your CALCULATE statements wrapping your SUM functions
Thanks, that works!
@markblom Try:
Sum of Sales Zero =
VAR __Result = IF( [Sum of Purchases] = BLANK() && [Sum of Sales] = BLANK(), BLANK(), SUM(Sales[Quantity]) + 0
RETURN
__Result
Also, there is no reason for your CALCULATE statements wrapping your SUM functions