Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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!