Dax Measure to Filter Visuals Based on Slicer

Hi evgeniam ,

I did these steps.
Is the slicer you want?
What columns did you add to the table?

Then, I tried to reconstruct your measure, but I didn’t quite understand the conditions in the formula:

          MAX(RevenueDetail[Secondary Workgroup]) = Workgroup ||  ISBLANK(MAX(Revenue Detail[Secondary Workgroup]))

For example:
if [EmployeeID] = 2,
[Workgroup] = 12 || 14,
[Secondary Workgroup] = 12 || 14,
How do you want to compare these two values?

I created a measure like this:

Measure 4 = 
VAR X =
CALCULATE(
    MAX( [Workgroup]),
    ALLEXCEPT(
        Employee,
        Employee[EmployeeID ]
    )
)
VAR y = 
CALCULATE(
    MAX('Revenue Detail'[Secondary Workgroup]),
    ALLEXCEPT(
        'Revenue Detail',
        'Revenue Detail'[EmployeeID]
    )
)
RETURN
IF(
    ISFILTERED(Employee[Workgroup]),
    IF(
        X = y || ISBLANK(y),
        1,0
    )
)

If it’s not true, please tell me more specific information and give me a sample data model.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.