Multiple filters, trying to include not equal to

Question

The DAX I list below is working fine, but I'm off my DAX game today and when I try to also exlude some values from a different column in the same table I end up just summing everything that doesn't have them which gives every item the same sum.&nbsp;I want to exclude any instances where&nbsp;udv_SalesItems[Item Produc ID ud5]&nbsp;is equal to "1307", "1320", "1321", or "1322"&nbsp;Current code without exclusion:2018 Item Count = CALCULATE(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SUM(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;udv_SalesItems[Value Item Qty]), &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;udv_SalesItems[Item_Class] IN {"FG1001", "FG1002", "FG1003", "FG1005"}, &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;udv_SalesItems[Date_Year] = 2018&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )

az38 · Answer

Hi&nbsp;noannish&nbsp;try2018 Item Count = CALCULATE(
      SUM(
                                     udv_SalesItems[Value Item Qty]),
                                     udv_SalesItems[Item_Class] IN {"FG1001", "FG1002", "FG1003", "FG1005"},
                                     udv_SalesItems[Date_Year] = 2018,
NOT (udv_SalesItems[Item Produc ID ud5] IN {"1307", "1320", "1321",  "1322"})
                                  )do not hesitate to give a kudo to useful posts and mark solutions as solutionLinkedIn&nbsp;

noannish · Answer

Thank you for trying, unfortunately it still sums everything where those ud5s do not exist, giving every item the same amount. Not the end of the world that I can't figure out how to do it within the measure, just would have been nice.

az38 · Answer

noannish&nbsp;maybe2018 Item Count = CALCULATE(
      SUM(udv_SalesItems[Value Item Qty]),
      FILTER(ALL(),
     AND(AND(udv_SalesItems[Item_Class] IN {"FG1001", "FG1002", "FG1003", "FG1005"},
                                     udv_SalesItems[Date_Year] = 2018),
NOT (udv_SalesItems[Item Produc ID ud5] IN {"1307", "1320", "1321",  "1322"}))
      )
)do not hesitate to give a kudo to useful posts and mark solutions as solution

Forum Discussion

Multiple filters, trying to include not equal to

3 Replies

Related content

How to include multiple columns in Activator

Multiple Years Filter

Mass Filter (should not include Exclude option)

DAX FILTER with multiple criteria

CALCULATE with multiple filters