Forum Discussion
Filter Data Based On Matrix Values
I have a dataset that looks like the following: Projected Utilization: EmployeeID WorkStatus Date FTE% 55 Firm 4/1/22 .50 55 Table 1 4/1/22 .50 55 Table 2 4/1/22 .25 55...
Hi wesleygeddes ,
Why there would be a value like "table3" in the Assigned Utilization [Assigned FTE]?
Are you want something like this?
Measure = IF(sum('Projected Utilization'[FTE%])<SUM('Assigned Utilization'[Assigned FTE]),"Under","Over")
Best Regards,
Jay
I have a measure that is almost identical to this one and it does work when I place that measure inside of the matrix. But if I wanted to filter the matrix to only show me people who are "Under" or "Over" (meaning in one of the months being displayed, they are "under") then I am unable too.