Filter matrix line when value are once negative

[jmgobet]

Hi community,

I am trying to filter value in a matrix to show only lines when value are once negative. (This is a supply chain dashboard and the idea is to identify planed item shortages)

I have the following dashboard:

The above matrix display item when bellow zero but in fact it appears that the filter

#qte cumul is less than 0

only display lines when the *final* value is negative but not a line that is negative one month and then ok the other months.

Anyone would have a idea how to better filter the matrix in order to display all the shortages?

Thanks in advance,

JM

[Anonymous · Accepted solution]

HI @jmgobet,

It seems like you are trying to filter summarize values, I'd like to suggest you create a measure with summarize function to manually aggregate your records based on current categories and use it as a filter on 'visual level filter' to filter records.

Measure Totals, The Final Word 

Applying a measure filter in Power BI 

If above not help, please share a pbix file with some dummy data to test.

How to Get Your Question Answered Quickly  
Regards,

Xiaoxin Sheng

[amitchandak]

@jmgobet , I can not see the row value, Create a measure with all expected, which same as row total and use that in the filter 

Calculate([Measure], allexpcept(Table,Table[Col]))

https://www.sqlbi.com/articles/using-allexcept-versus-all-and-values/