Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to 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
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
Hi,
I think this external guide can help you: https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/
User | Count |
---|---|
86 | |
84 | |
69 | |
67 | |
55 |
User | Count |
---|---|
125 | |
100 | |
90 | |
84 | |
66 |