Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
welcome
Can you help me to convert this instruction to Dax
select count(distinct(CustomerCode)) from Tab1
where Fld1=@Var1 and CustomerCode not in(select distinct(CUSTOMER_NO) from Tab2 where Fld1=@Var1)
Solved! Go to Solution.
@msit19 , Try like
meausre =
calculate(distinctcount(Tab1[CustomerCode]) , filter(Tab1, not( CustomerCode in values(Tab2[CUSTOMER_NO]))))
meausre =
calculate(distinctcount(Tab1[CustomerCode]) , filter(Tab1, not( CustomerCode in allselected(Tab2[CUSTOMER_NO]))))
Assuming Fld1 from both tables is joined to common dimension and that dimension is used as a slicer to filer values
Another option in place of in is treatas
https://docs.microsoft.com/en-us/dax/treatas-function
@msit19 , Try like
meausre =
calculate(distinctcount(Tab1[CustomerCode]) , filter(Tab1, not( CustomerCode in values(Tab2[CUSTOMER_NO]))))
meausre =
calculate(distinctcount(Tab1[CustomerCode]) , filter(Tab1, not( CustomerCode in allselected(Tab2[CUSTOMER_NO]))))
Assuming Fld1 from both tables is joined to common dimension and that dimension is used as a slicer to filer values
Another option in place of in is treatas
https://docs.microsoft.com/en-us/dax/treatas-function
thanks for your reply I don’t want to add a condition to the second table How ?
select count(distinct(CustomerCode)) from Tab1 where Fld1=@Var1 and CustomerCode not in(select distinct(CUSTOMER_NO) from Tab2 where Fld1=2000)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
43 | |
23 | |
21 | |
15 | |
15 |
User | Count |
---|---|
46 | |
31 | |
30 | |
18 | |
18 |