Forum Discussion
Measure with table variable to filter table visual
Hi rack201
I ran the testing as follows.
tables:
The table acts as a slicer.
Create a measure as follows
Measure = VAR _supername = CALCULATE(MAX('Table'[Supervisor Name]), FILTER('Table', [Staff Name] = SELECTEDVALUE('staff'[Staff Name]))) RETURN IF(MAX('Table (2)'[Supervisor Name]) = _supername && MAX('Table (2)'[Staff Name]) <> SELECTEDVALUE(staff[Staff Name]), 1, 0)Put the measure into the visual-level filters, set up show items when the value is 1.
Is this the result you expect?
If I've misunderstood you, please provide the result you are hoping for. Please remove any sensitive data in advance.
Best Regards,
Yulia XuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi rack201
I ran the testing as follows.
tables:
The table acts as a slicer.
Create a measure as follows
Measure =
VAR _supername = CALCULATE(MAX('Table'[Supervisor Name]), FILTER('Table', [Staff Name] = SELECTEDVALUE('staff'[Staff Name])))
RETURN
IF(MAX('Table (2)'[Supervisor Name]) = _supername && MAX('Table (2)'[Staff Name]) <> SELECTEDVALUE(staff[Staff Name]), 1, 0)
Put the measure into the visual-level filters, set up show items when the value is 1.
Is this the result you expect?
If I've misunderstood you, please provide the result you are hoping for. Please remove any sensitive data in advance.
Best Regards,
Yulia Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
