Forum Discussion
Nested (3 levels) TOPN using Power BI DAX not working for categories but working for other
Hi TFRec
lbendlin already provided a very good approach, but still, if you seeking another way of doing that you can check this video this is not exact but with some modification this might help you to attain solution: https://youtu.be/cs2AwJljBrQ?si=yQR7T5WZZMfTaSDh
Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Check for more intersing solution here: www.youtube.com/@Howtosolveprobem
Regards
Super UserYou will have to create three calculated tables, either materialized or as part of the measure (there might be severe performance issues in the latter approach, especially with your amount of data). You need to start from the lowest level as I showed, and then need to use the result of that for the next level, and then the result of that for the top level.
Certainly doable but rather complex. Think about softening your requirement, or finding a graphical solution instead (like a decomposition tree)
Hello lbendlin ,
Thank you very much for the help. I fear creating new tables I would impede a lot of the dynamic use of slicers, filters, etc. on the report unless I went the route of using new tables just for the list of values and then still dynamically calculate the values associated to them (which is doable), so I ended up using the approach indicated by another user.