Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

o

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
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Anonymous,

Try this measure:

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

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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