Forum Discussion
DAX help from table join
Need translate those sql into DAX. SELECT COUNT(DISTINCT b.billId) AS BilledCount FROM Bill b WITH (NOLOCK) LEFT JOIN dbo.Transactions t ON (b.Billid = t.billid) WHERE t. TransactionTyp...
Hi JulietZhu,
AkhilAshok just explained and gave the solution. Please try it out in your model.
Best Regards,
Dale
v-jiascu-msftAkhilAshok, the DAX I used actually is correct becuase when I only choose those 3 tables in my data modeling, both DAX I used are correct. Since there are other tables in data modeling, several ways can do calcuation. That is why whatever DAX are used, it won't give the correct answer.
The solution for this is that I write sql query in database and bring in another fact table in my data modeling. Thanks for helping.