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 funtion to or solution to fix this?

 

matrix in reportrelationships

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)

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hello Anonymous,

    you can create new column in DAX with simple formula:

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

    That should do :smileywink:

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      It turned out like:

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

  • v-yuta-msft's avatar
    v-yuta-msft
    Icon for Community Support rankCommunity 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

    • Anonymous's avatar
      Anonymous
      Not applicable
      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)