cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Anonymous
Not applicable

## Replacing Blanks with 0 - Adding +0/ new measure not working!

Hello,

I have been trying to replace Blank values as 0 in my matrix visualisation. I have tried using +0 in a new measure and dax functions but no luck. Below is an example of my data and what i am trying to do. Please share your ideas!!

 Direction Category Date I 1 17-Jun B 2 18-Jun B 3 17-Jun I 1 18-Jun I 2 20-Jun I 4 21-Jun B 5 19-Jun

I am trying to add values as "0" when the count of category for a specific date is null.

6 REPLIES 6
Anonymous
Not applicable

Adding 0 to a number/measure (like COUNT) always forces the display of a number. ALWAYS. The fact that you can't see 0's in your matrix points in a different direction. I'd check the formatting of the values in the table. Maybe 0's are formatted as BLANKS by the matrix? Can you check some other visuals?

Best

Darek

Resident Rockstar

What is the measure you are currently using to fill this table?  What measures using the +0 trick have you tried?

Anonymous
Not applicable

I have used the following dax:

count = count([category]) + 0

count = if(isblank(count([category)),0,count([category]))

```Child Count =
VAR rowcount =
COUNTROWS ( Child )
RETURN
IF ( rowcount = BLANK (), 0, rowcount )​```
count of category = IF(COUNTX(VCCdata,VCCdata[Category]) = 0, 0, COUNT(VCCdata[Category]))
```ActualM =
IF (
CALCULATE ( SUM ( Expenses[Actual] ) ) = BLANK (),
0,
CALCULATE ( SUM ( Expenses[Actual] ) )
)```
Resident Rockstar

Using your first measure (count = count([category]) + 0), I was able to get this:

Could you share a screenshot of the fields you have in your Rows/Columns/Values buckets in the visualization pane?

Anonymous
Not applicable

I have also used the same measure in the above screenshot. I tried performing the same for various sets of data i have but still end up getting the same. If i am changing count = count([category])+0 to count=count([category])+1, only the fields in the table withvalues get updated and the blank values remain the same.

Anonymous
Not applicable
`[Category Count] = DISTINCTCOUNT( T[Category] ) + 0 `

Always use the name of the table in front of the column. ALWAYS. And never do that in front of measures. NEVER.

Best

Darek

Announcements

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

#### Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors