Filter by Matrix Subtotals_12122023.pbix

Goal

Filter by conditions on the parent level but contains all child level rows

Solution

Filter = 
IF( CALCULATE( [Rate],
ALLEXCEPT('Table','Table'[PHA])) < 0.955 , 1, 0)

Untitled