Need DAX for filter matrix data for second level group by total based on search number input box val

Hi Anonymous ,

You can try this DAX-

Show Row Flag =
VAR SelectedView = SELECTEDVALUE('Select View'[View]) -- "Total" or "Sub Total"
VAR Threshold = SELECTEDVALUE('ThresholdValue'[Value]) -- User input

VAR GroupLevelTotal =
SWITCH(
SelectedView,
"Sub Total", CALCULATE(SUM('Sales'[Amount]), ALLEXCEPT('Sales', 'Sales'[Location])),
"Total", CALCULATE(SUM('Sales'[Amount]), ALL('Sales')),
BLANK()
)

RETURN
IF(GroupLevelTotal > Threshold, 1, 0)

This measure calculates the subtotal per Location or overall total, depending on the selected view.
Then apply visual level filter and set it to 1.
This will keep the detailed rows, but only for groups where the group subtotal or total exceeds the threshold.
Hope this helps!