Matrix table subtotal

[Anonymous]

Hi

i am trying to do this on a matrix table in powerbi, i have suceeded in putting a colout red for negative values for subtotals but i want to drill to another visuals that shows only the red subtotals meaning where the subtotal is negative value.

i wrote a measure that shows this but it is fltering all the negative values i only want it to filter per catergory subtotal with a negative value .

Please can anyone help

[amitchandak]

@Anonymous , Those drilled visuals need to have a filter on measure value <0, Measure can not pass the filter, only categorical data (row/column) can be passed.