Forum Discussion

BlueTeam1's avatar
BlueTeam1
Frequent Visitor
6 years ago

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 columns (both measures). How do you filter out based on the cumulative in DAX?

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    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's avatar
      BlueTeam1
      Frequent Visitor
      6 years ago

      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