Replacing (Blanks) with 0

[Sebas2404]

Dear All,

For a production report I'm presenting production numbers based on hours.

In some situations the machine did not produce any parts so there is no value for that hour.

Is there a funtion to or solution to fix this?

matrix in reportrelationships

[v-yuta-msft]

@Sebas2404 ,

Click-> Query Editor-> Replace Values and input replace null with 0 like below:

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Sebas2404 · Accepted solution]

The solution didn't work.
I did solve it by creating a new measure:

HourlyCount = var HourlyCounter = CALCULATE(SUM(CounterTable[Value]))
return IF(ISBLANK(HourlyCounter), 0, HourlyCounter)

[Sebas2404]

v-yuta-msft,

This will be valid if the table where the value would null.

The problem is I link two seprate tables to fill the matrix.

If the table of shift time is static and only holds 24hours and some tekst to make the report more clear.

24hours table

I dont get the date from the machine in the database for each hour. The database simple has no line for the production counter if it has not produced any

table with machine numberresults in matrix

[Anonymous]

Hello @Sebas2404,

you can create new column in DAX with simple formula:

"New Shift Time = IF(Shift[Column] = "", "0", Shift[Column])"

That should do

[Sebas2404]

It turned out like:

HourlyCount = var HourlyCounter = CALCULATE(SUM(CounterTable[Value]))
return IF(ISBLANK(HourlyCounter), 0, HourlyCounter)