How to to set the column or card 0 if there is no data

[hasaneyldrm]

Hi how's the lockdown going, i hope you are fine 😊

On the powerBI screens "if there is no record, I want it to write 0 to the UI card"

I did these steps:

I wrote a measure using "countrows" that returns true if there is no record, and return false if there is no record.

I have created a column that allows to write 0 if the value from measure is true (if there is no data), and if not, enter the existing value.

Null checks are working (I can see yes or no data) but I could not get the column "to set the column 0 if there is no data"

[AllisonKennedy · Accepted solution]

@hasaneyldrm  Why do you need the extra NullCheck measure? A measure adds CALCULATE() around it, so behaves a bit differently than using the actual formula in some scenarios. 

Additionally, a COLUMN will NEVER use a MEASURE result in the way you expect, due to Power BI Order of Operations 

Try creating a MEASURE:

NullLogs = IF(ISBLANK(COUNTROWS(time_entries_all)), 0, SUM(time_entries_all[time]))

You can change SUM to AVERAGE or whatever aggregation you had on the [time] column in your visual in screenshot.