Power BI
NewSelecting/cross-highlighting a filter-based measure should filter the rest of the dataset
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.