Filter based on Cumulative Value

[BlueTeam1]

Hello,

I am kinda new to Power BI. I have a report that runs a matrix that shows inventory across time, The user wants me to filter out the items that have cumulative quantities of zero in two columns (both measures). How do you filter out based on the cumulative in DAX?

[amitchandak]

@BlueTeam1 , Create a a measure like this and use that in visual level filter of as measure filter

calculate([measure],allexcept(table,Table[Item]))

[BlueTeam1]

@amitchandak That appears to also filter out months with zero below the Item. I would be looking to avoid this, only filtering if the totals of both measures across all months are zero. Sorry if I was not clear