Forum Discussion
Why my TOPN does not work ?
Hi admin_xlsior ,
I create a sample data according to your description and did some test. While using 'group' from 'item groups' table it will show all groups. While using 'group' from 'products' table it will show correct result.
Best Regards,
Jay
admin_xlsior , I doubt that too. Can check does it work with group in products.
If so the options are merge the product and group in power query as a work around.
and Log and issue : https://community.powerbi.com/t5/Issues/idb-p/Issues
Hi amitchandak
Yup, did tried that, and it is same result, not working. So is it a bug ? Quite strange but let me try to log.
Thanks,
Hi admin_xlsior ,
I create a sample data according to your description and did some test. While using 'group' from 'item groups' table it will show all groups. While using 'group' from 'products' table it will show correct result.
Best Regards,
Jay
