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! 🙂
Measure equals to/larger than shows blank results
Hi masters, i have the following measure, which counts the customers who have more than zero referrals for the last 6 month and WORKS FINE: Customers MGM Referrals L6 Months = CALCULATE(Customers[# Customers],filter(MGM,[MGM Referrals NEW L6 Months]>0)) BUT: when i want to calculate those with exactly 1 referral it shows blank: Customers MGM Referrals L6 Months 1 = CALCULATE(Customers[# Customers],filter(MGM,[MGM Referrals NEW L6 Months]=1)) It shows blanks for any "equal/larger than x". Please note that the above combines 2 different data tables (Customers & MGM). Any idea??? i am lost here. Thanks in advance, Amit
