Join Table Dax Command

[pityman]

Hi,

How do i convert below sql to Dax?

Select COUNT(*) from ADStatus ADS , ADLink ADL

where

ADS.TDId = ADL.TDID AND ADS.ToStatus = '7' AND ADL.StatusId != 12

[v-kelly-msft · Accepted solution]

Hi @pityman，

First create a new table as below:

Table = CROSSJOIN('ADL','ADS')

Then create a measure as below:

Measure = CALCULATE(COUNTROWS('Table'),FILTER('Table','Table'[TDID]='Table'[TDId2]&&'Table'[StatusId]<>12&&'Table'[ToStatus]=7))

For the related sample .pbix file,pls see attached.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[edhans]

You don't. DAX isn't SQL. DAX doesn't have joins, it has filter relationships. If you want to join data, do it in Power Query using a merge. Otherwise, please posts data and show us what you are trying to accomplish, but I am pretty sure DAX will not be the solution here. DAX is for analysis, not transformations.