Skip to main content
Microsoft Idea

Power BI

Needs Votes

Selecting/cross-highlighting a filter-based measure should filter the rest of the dataset

Vote (3) Share
Ryan McCauley's profile image

Ryan McCauley on 30 Jul 2019 04:45:01

I've created measures that are based on FILTER statements to count rows/items in a certain situation, like this:

Overdue Customers = CALCULATE(COUNTROWS(Customers), FILTER(OverdueBalance > 0))

When I have multiple measures on a single bar chart, I should be able to highlight one and filter the rest of my dataset - in this case, to see which customers (from a matrix visual) are overdue or how their balance has trended over time (in a line chart).

If the measure uses a SUM or COUNT that doesn't filter anything, then this wouldn't apply - but in cases where the measure has to perform a FILTER operation, a cross-highlight of that measure should propagate the the filter into the rest of the dataset so you can see all the data that went into the calculation.