Forum Discussion
Filter based on Cumulative Value
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 co...
amitchandak
Super User
Super UserBlueTeam1 , Create a a measure like this and use that in visual level filter of as measure filter
calculate([measure],allexcept(table,Table[Item]))
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