Forum Discussion

Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago
Solved

Interesting Problem with Attendance

Had an interesting attendance issue come up at my user group recently. Basically it centers around attendance. The goal is to present a table/matrix visualization that displays all Employees within a...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    OK, I may have solved this, I think changing the Measures to Show measure to this fixes it:

     

    Measures to Show = 
IF(
     HASONEVALUE(Employees[Employee]),
     SWITCH(
          VALUES(Attendance[Attendance]),
          "Attended",[Attended],
          "Not Attended",[NotAttended]
	 ),
	 MAX([Date])
)

    It seems that this forces it to honor the matrix context from what I can tell.

     

    I would still REALLY love to know what is going on with the other way though. Is it because Employee is in the matrix, then it honors the context of the matrix but since Attendance is not explicitly in the matrix, it does not honor the matrix context??

Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

OK, I may have solved this, I think changing the Measures to Show measure to this fixes it:

 

Measures to Show = 
IF(
     HASONEVALUE(Employees[Employee]),
     SWITCH(
          VALUES(Attendance[Attendance]),
          "Attended",[Attended],
          "Not Attended",[NotAttended]
	 ),
	 MAX([Date])
)

It seems that this forces it to honor the matrix context from what I can tell.

 

I would still REALLY love to know what is going on with the other way though. Is it because Employee is in the matrix, then it honors the context of the matrix but since Attendance is not explicitly in the matrix, it does not honor the matrix context??