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.
I create a calucation item "Margin calculation" in a calculation group, if I use it directly in a visual, it works,
But when I use it in measure
I don't know what's wrong with the measure, is there any possible causes ?
Hi @Lesle
The details is not enough to help troubleshoot this issue. Can you share the DAX expressions of the calucation item "Margin calculation" and [Product Mix]? Is [Product Mix] an explicit measure? Calculation items only apply to measures or explicit measures.
Best Regards,
Jing
It seems you have used a field parameter in the calculation item. Where do you use this field parameter in the report? Does it filter different item when you see the difference?
I used the field parameter as row of the table, you can see "Parameter - Dimension" in the picture. I wanna realize that the calculation item can SUMX different dimension as per the field I selete in the parameter
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
83 | |
64 | |
60 | |
55 |
User | Count |
---|---|
179 | |
108 | |
105 | |
71 | |
70 |