Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
User | Count |
---|---|
65 | |
46 | |
20 | |
18 | |
15 |
User | Count |
---|---|
120 | |
41 | |
40 | |
28 | |
23 |