Forum Discussion
Measure's value as a filter value
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!
I understand that I cannot add measure as slicer. The Measure has only one 9 digit number as value (like 980211541) I want to use the actual value (which are changing based on user's interaction) to filter rows. I cannot add measure’s value to filter pane as value for Advanced filtering.
I need something like that:
SuperVisorID
Shows items when the value
is
[the actual value of the Measure]
Super UserYou 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!
- ray_aramburo
Great approach!