Forum Discussion
DAX: TOPN Function Error
Hi all! A beginner here and I would appreciate the help :) I need help in creating a measure in DAX and I don't know if my execution is correct. The thing that I would like to happen is to produce a g...
Hi Cherry!
I still haven't figured it out. Can you pls help me? Here is the code that I made.
I know that he suggested RANKX as a new calculated column, however I still don't get the execution I should do. This is my desired output:
With the measure I created which is seen in the first photo, I was able to filter the Assignee's and the status = "In-Progress". However, I would want to include a TOPN dax measure to get the top 5 assignees with the most number of in-progress status and display my desired output. I know that there's an option wherein you can do it using Visual Level filters:
But I would really love for everything to be created as a measure. And not use the visual level filters anymore. Please let me know if you could suggest a measure that I could use for this :) Thank you!
Hi Anonymous,
Thanks for your desired output.
Please share your data sample which could reproduce your scenario so that I can copy and test on it.
Best Regards,
Cherry
Hi cherry!
Thank you so much for your reply. Here is my data sample:
Let me know if you need additional details. I super appreciate the help :)