Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Replacing (Blanks) with 0

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 fu...
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    7 years ago

    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)

v-yuta-msft's avatar
v-yuta-msft
Community Support
7 years ago

Anonymous ,

 

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.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

,

 

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