Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
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
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 9 | |
| 5 | |
| 4 | |
| 3 | |
| 3 |
| User | Count |
|---|---|
| 22 | |
| 12 | |
| 10 | |
| 10 | |
| 9 |