o

[Anonymous]

Time Sheet Compliance - show missing time sheet en... 

I am trying to count the number of blank cells and display in the matrix

Please help

[Anonymous]

I am trying to count the number of blank cells and display in the matrix

Please help

[Anonymous]

@Anonymous, 

Without looking at the actual data model, I would suggest you use COUNTBLANK Function 

[Anonymous]

Very new to PowerBi, would that be considered a measure?

[Anonymous]

does the count blank function work on my matrix I already made?

[Anonymous]

@Anonymous,

Provide screenshot of your data model (with relationship) and the full matrix view will help me to provide you a correct answer.

[Anonymous]

@Anonymous,

Try this measure:

Blank Timesheet Count = COUNTROWS(ALL(Timesheet[Timesheet Date])) - COUNTROWS(VALUES(Timesheet[Timesheet Date]))

[Anonymous]

 The most people havem issed is like 5 or 6, but the measure is giving insane numbers, any ideas?

[v-yuezhe-msft]

@Anonymous,

It seems that you have a different question. Could you please share sample data of your original table and post expected result based on the sample data?

Regards,
Lydia