Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Filtering Matrix by Subtotal

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 ...
Need Help
v-alq-msft's avatar
v-alq-msft
Community Support
5 years ago

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's avatar
    Anonymous
    Not applicable
    5 years ago

    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!