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.
Solved! Go to Solution.
You need to use CONCATENATEX to concatenate your results. It does not work as you write it because topN is a table where as DAX measure's result should be scalar.
Look at this video, it explains very well the steps to be taken ( Create insightful calculations using CONCATENATEX goodly)
https://youtu.be/xVLi31mOxeo?si=pONk1uUfEoLXD91t
If it answers your query, please mark my reply as the solution. Thank you!
You need to use CONCATENATEX to concatenate your results. It does not work as you write it because topN is a table where as DAX measure's result should be scalar.
Look at this video, it explains very well the steps to be taken ( Create insightful calculations using CONCATENATEX goodly)
https://youtu.be/xVLi31mOxeo?si=pONk1uUfEoLXD91t
If it answers your query, please mark my reply as the solution. Thank you!
User | Count |
---|---|
70 | |
43 | |
21 | |
21 | |
14 |
User | Count |
---|---|
124 | |
42 | |
39 | |
28 | |
24 |