Forum Discussion
Solved
Measure's value as a filter value
Hi All, I have an apparently very simple task but I can't solve that. I have a measure (Selected supervisor) which contains the actul value of a Swith () function (within multiple ISFILTERED...
I was able to solve the problem.
I created an additional measrue:Matching Supevisor = IF(VALUES(USERS[Supervisor ID]) = [SELECTEDSupervisorID], 1,0)
Than I filtered Matching Supevisor to 1 and got the desired result.
Thank you for your help at all!
You can only place a measure in the filter pane cards without referring to an explicit value in Top N type filters, otherwise is not possible.
I was able to solve the problem.
I created an additional measrue:
Matching Supevisor = IF(VALUES(USERS[Supervisor ID]) = [SELECTEDSupervisorID], 1,0)
Than I filtered Matching Supevisor to 1 and got the desired result.
Thank you for your help at all!
Great approach!