Forum Discussion
Solved
Matrix Conditional Formatting correct in totals but not values
Hi, I am currently building a matrix that has 2 row values and one column. I have formatted this matrix to colour based on whether a role is over/under/within capacity for that month. The current...
In case anyone is curious or has the same issue, I found that because my capacity was also marked within the time type column, it was filtering it out in the matrix (as I only added project and request types together). This measure solved the issue for me:
Capacity = CALCULATE([Time],ALLEXCEPT('Hours Planned','Hours Planned'[Month Year],'Hours Planned'[Role]),'Hours Planned'[Time Type] = "Capacity")So it only added together capacity lines and kept the month year filter from the matrix, but ignored the time type filter that the matrix was imposing.
In case anyone is curious or has the same issue, I found that because my capacity was also marked within the time type column, it was filtering it out in the matrix (as I only added project and request types together). This measure solved the issue for me:
Capacity = CALCULATE([Time],ALLEXCEPT('Hours Planned','Hours Planned'[Month Year],'Hours Planned'[Role]),'Hours Planned'[Time Type] = "Capacity")
So it only added together capacity lines and kept the month year filter from the matrix, but ignored the time type filter that the matrix was imposing.