Convert SQL Query to DAX Measure

[Anonymous]

Hi All,

I have the following query in SQL

Select da.AreaKey,AreaNumber from dimarea da
inner join factarea fa on fa.Areakey = da.AreaKey
where m2m = 0

 I wan't to create a DAX measure for that SQL query in Power BI. How to write this SQL query in DAX Measure

[v-mengzhu-msft · Accepted solution]

Hi @Anonymous ,

Due to the lack of many relevant data as a basis, I can only write a simple one for your reference.Like this:

measure= var _table= summarize('dimarea da',[da.Areakey],[AreaNumber])
return calculate(expression, filter([m2m]="0",[da.Areakey] in selectedvalue([fa.Areakey])

Related dax function used above link are as the following show :

SUMMARIZE function (DAX) - DAX | Microsoft Learn

CALCULATE function (DAX) - DAX | Microsoft Learn

FILTER function (DAX) - DAX | Microsoft Learn

SELECTEDVALUE function - DAX | Microsoft Learn

Hope these can help you.

Best regards,

Community Support Team Selina zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[PowerUserR]

Hi,
I think this external guide can help you: https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/