topic Filter based on Cumulative Value in DAX Commands and Tips

Filter based on Cumulative Value

BlueTeam1 — Mon, 31 Aug 2020 17:20:36 GMT

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?

Re: Filter based on Cumulative Value

amitchandak — Mon, 31 Aug 2020 17:59:57 GMT

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

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

Re: Filter based on Cumulative Value

BlueTeam1 — Thu, 17 Sep 2020 20:10:22 GMT

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