filter one column in one table to another column in another table
Henlo, I am needing to add a measure that filters out data from my matrix. I am needing only rows returns that match this criteria ( {IM_ItemWarehouse.WarehouseCode} = {CI_Item.DefaultWarehouseCode} ) I know how I can do this in power query but I have other visuals that do not require the same filtering. Can someone help me with how I would create a measure to accomplish this? Oodles of thanks in advance! 🙂
Multiple filters, trying to include not equal to
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. I want to exclude any instances where udv_SalesItems[Item Produc ID ud5] is equal to "1307", "1320", "1321", or "1322" Current code without exclusion: 2018 Item Count = CALCULATE( SUM( udv_SalesItems[Value Item Qty]), udv_SalesItems[Item_Class] IN {"FG1001", "FG1002", "FG1003", "FG1005"}, udv_SalesItems[Date_Year] = 2018 )
