Filter Matrix by Negative Value Based on Subtotal by First Row

Hello JxSCy_8819 

could you please share a visual representation of your problem. that would be helpful . 

best regards

Hi JxSCy_8819 ,

Based on the question you provided, since you put multiple Rows in the matrix, when filtering for Net Revenue less than -1, the final total you get is the sum of all values less than -1.

You can add just one piece of data to the Rows to achieve your desired result:

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

^{Best Regards,}

^{Ada Wang}

^{If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.}

Hi Anonymous , I need the matrix with sub customer and project number info with the output result -7, instead of -15.