I have search the various solutions but I still cannot show a 0 instead of a blank.I am using a matrix visual to display my data.
I have tried the following
Sales Quantity =IF ( CALCULATE ( SUM (Sales[Invoice_Qty] ) ) = BLANK (), 0, CALCULATE ( SUM (Sales[Invoice_Qty] ) )
I also tried
Sales Quantity = IF ( ISBLANK(SUM(Sales[Invoice_Qty])), 0 ,SUM(Sales[Invoice_Qty]))
Go to Solution.
You may take a look at the following post.
View solution in original post
I did not succeed in displaying the zeros - I will close this as I have moved on from the issue and published the report without showing the zeros - it was going to be a nice to have for the user.
thanks to all for their help
Try the following:
Sales Quantity =
LEN(CALCULATE ( SUM (Sales[Invoice_Qty] ) ) ) = 0,
CALCULATE ( SUM (Sales[Invoice_Qty] ) )
No - it is still displaying blanks instead of 0's
Any chance to send a snapshot of your formula and your output table?
If you could also share the workspace that would be great. Mask any sensitive data
Kudos to you if you earned one of these! Check your inbox for a notification.
Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.
Find out where you can attend!