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

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

 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Anonymous,

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

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