I'm a beginner with semantic link, the command below caused an error. "duration" is the field I created to store measure [Phase Duration(M)]. But if I run the same measure by group by, it works.

try using ADDCOLUMNS and/or wrapping the measure in a CALCULATE()

Hi Jeanxyz, Thankyou lbendlin for your response regarding the query. I'm glad that your query was resolved. If the response provided by the community member addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone. Thank you for your understanding!

Hi Jeanxyz Following up to check whether you got a chance to review the suggestions given. If the issue still persists please let us know. Glad to help. If our response has addressed your query, please accept it as a solution and give a ‘Kudos’ so other members can easily find it. Please let us know if there’s anything else we can do to help.TRhank you.

My goal is to understand why the summarizecolumn query failed. Hence it's not really solved yet.

Hi Jeanxyz, Thank you for using Microsoft Community Forum. The reason your SUMMARIZECOLUMNS query is failing is due to how DAX processes calculated fields within that function. When you define "Duration" as a calculated field using the measure [Phase Duration(M)], DAX doesn't recognize it properly. Instead of evaluating it as a measure, it treats it as a generic object (System.Object), which is unsupported by SUMMARIZECOLUMNS. SUMMARIZECOLUMNS only works with existing columns and measures. If you try to create a calculated column on the fly, DAX fails to resolve it correctly. To make this work, you need to wrap the measure calculation in a CALCULATE() function to ensure it's evaluated properly within the row context. If this suggestion helped you, kindly mark it as Accept as Solution and feel free to give a Kudos, it would be much appreciated!Thank you.

need help with semantic link syntax | Microsoft Fabric Community

12 Replies

lbendlin
Super User
1 year ago
try using ADDCOLUMNS and/or wrapping the measure in a CALCULATE()
v-sgandrathi
Community Support
1 year ago
Hi Jeanxyz,

Thankyou lbendlin for your response regarding the query.

I'm glad that your query was resolved. If the response provided by the community member addressed your query, could you please confirm?
It helps us ensure that the solutions provided are effective and beneficial for everyone.

Thank you for your understanding!
- v-sgandrathi
  Community Support
  1 year ago
  Hi Jeanxyz
  
  Following up to check whether you got a chance to review the suggestions given. If the issue still persists please let us know. Glad to help.
  
  If our response has addressed your query, please accept it as a solution and give a ‘Kudos’ so other members can easily find it. Please let us know if there’s anything else we can do to help.
  
  TRhank you.
  - Jeanxyz
    Power Participant
    1 year ago
    My goal is to understand why the summarizecolumn query failed. Hence it's not really solved yet.

Forum Discussion

need help with semantic link syntax

12 Replies

Related content

Syntax problem

SQL Query Syntax issue

Semantic Model

Healthcare Semantic Model

SQL syntax error