Forum Discussion
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...
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
Community Support
Community SupportAnonymous ,
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.
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)