Filter Matrix by Negative Value Based on Subtotal by First Row

[JxSCy_8819]

Hi, there were multiple rows and values in my matrix, when i try to filter by -1 using one of the values in visual filter, it turns out filter based on single breakdown value in second row. I would like to filter negative value (-1) after subtotal by first row only. Many thanks for any suggestions.

[JxSCy_8819]

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

[Anonymous]

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.}

[JxSCy_8819]

[JxSCy_8819]

[Daniel29195]

Hello @JxSCy_8819 

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

best regards