Filtering a Graphic Based on Selected Value and Measure

Hi Anonymous ,

 

Your issue is that you're using a DAX measure (IsUnderSelectedManager) to determine if an employee falls under the selected manager, but you're expecting it to act like a filter on the population graphic. Measures calculate values but they don’t filter rows unless used inside visuals that support measure-based filters, like cards or conditional formatting. They don’t work for directly filtering a table visual unless explicitly used as a filter expression.

The core problem is that SELECTEDVALUE() in your measure isn’t behaving as expected across rows. When used in a row context without a visual filter applied first, it often returns blank because multiple values exist. That’s why the population graphic shows nothing—it’s not getting a clean scalar value from the measure to evaluate against each row.

To debug this, use a table visual and drag in the employee name, both manager ID columns, and your IsUnderSelectedManager measure. Then select a manager and look at which rows return 1 versus blank. You’ll probably see that it doesn’t work as expected because the measure isn't evaluating row by row with the right context.

To fix this and make the filtering work as you intended, replace the measure with a calculated column like this:

IsUnderSelectedManagerColumn =
VAR SelectedManager = SELECTEDVALUE(ManagerList[ManagerID])
RETURN
    IF (
        ISBLANK(SelectedManager),
        1,
        IF (
            Population[WT_L1_MGR_ID] = SelectedManager ||
            Population[WT_L2_MGR_ID] = SelectedManager,
            1,
            0
        )
    )

This creates a column that reacts to the selection and can be used in visual-level filters. Note that SELECTEDVALUE inside a calculated column won’t be dynamic to slicers—because calculated columns are static once loaded—so this only works for simple, non-dynamic use cases.

If you need it to remain dynamic and change based on slicer selections, keep the measure but redesign the visuals to support filtering through CALCULATE or use it as a filter inside another measure. For table visuals, create a virtual table that filters only relevant employees using CALCULATETABLE or FILTER, then display that table through a separate visual, not relying on filters applied to the main table visual.

In short: measures calculate values, not filters. Calculated columns filter visuals but don’t respond to slicers. Choose one based on whether you want dynamic behavior or static filtering, and structure your visuals accordingly.

 

Best regards,