Forum Discussion

JulietZhu's avatar
JulietZhu
Icon for Helper IV rankHelper IV
7 years ago

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...
Need Help
JulietZhu's avatar
JulietZhu
Icon for Helper IV rankHelper IV
7 years ago

Here is relationship.

 

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi JulietZhu,

 

AkhilAshok just explained and gave the solution. Please try it out in your model.

 

 

Best Regards,
Dale