Forum Discussion
Power Participantneed help with semantic link syntax
Power ParticipantThanks for the explanation. I tried your advice, and write the query as below
******************
Community SupportHi Jeanxyz,
Try this Dax Measure:
Evaluate
SUMMARIZECOLUMNS(
'Sales Phase'[Sales Phase],
"duration", [Phase Duration(M)]
)
Ensure [Phase Duration(M)] is already a valid measure.
Phase Duration(M) = MEDIAN(Sales_Phase_Log[Phase Duration])
SUMMARIZECOLUMNS only allows measures and existing columns, not calculated expressions directly.
If this solution worked for you, kindly mark it as Accept as Solution and feel free to give a Kudos, it would be much appreciated!
Thank you.
- Jeanxyz
This is tried already. Not working, the measure [Phase Duration(M)] is valid, as it works evaluate measure expression.
- v-sgandrathi
Hi Jeanxyz,
Thank you for the update.
I understand that you have already tried this, and the measure [Phase Duration(M)] is valid.
Please note that SUMMARIZECOLUMNS always returns a table output, not a single value.
To view the results properly:
- Please use this query inside a Table visual in your Power BI report.
- Alternatively, you can run it in DAX Query View (available in the latest Power BI Desktop) to directly see the output.
If you try to use it directly in a card or as a scalar measure, it will not display properly, as a table result needs a table format to render.
Kindly try placing the output in a Table visual and check once.
Glad I could assist! If this answer helped resolve your issue, please mark it as Accept as Solution and give us Kudos to guide others facing the same concern.
Thank you.
- v-sgandrathi
Hi Jeanxyz,
We wanted to follow up since we haven't heard back from you regarding our last response. We hope your issue has been resolved.
If my answer resolved your query, please mark it as "Accept Answer" and give Kudos if it was helpful.
If you need any further assistance, feel free to reach out.
Thank you for being a valued member of the Microsoft Fabric Community Forum!