Filtering Matrix by Subtotal

[Anonymous]

Greetings All,

Apologies for the blacked out data (sensitive of course). I'm in a matrix here looking to either create a measure or filter, anything to allow me to only keep the rows where Count of FromDOS >= 3 (I have the below image placed specifically where the data should stop: the point where 3 falls to 2 in the Count of FromDOS column). On the left, I have claim numbers drilling down to service dates. Everything I have tried related to measures has resulted in numbers being placed ON THE SUBTOTAL LINE ONLY. Since the filters are unable to look at subtotals, doing a filter of "Count of FromDOS >= 3" results in the entire sheet going blank (since the value in the Count of FromDOS column is 1 in all cases). I'm looking for any possible solutions to this problem. Thank you.

[v-alq-msft]

Hi, @Anonymous 

I am confused about the expected result. Could you please explain the problem with some sample data and expected result with OneDrive for business? Do mask sentive data before uploading. Thanks.

Best Regards

Allan

[Anonymous]

Thank you for your reply! I'm not sure how to present mask sensitive data. The best way I can explain it is, wherever Count of FromDOS is >= 3 at the subtotal level, keep those rows and data. Where Count of FromDOS is < 2 at the subtotal level, filter out that data. In the above image, I drilled down specifically at the point where the data should be cut off. All rows and data below the 1/19/2021 line should be cut off from the matrix. Any assistance would be greatly appreciated!