Forum Discussion
admin_xlsior
Post Prodigy
Post ProdigyWhy my TOPN does not work ?
Hello guys, Need help on some TOPN function. When I have this kind of data relationship: Then I create a Top 2 measure based on Item group like this: Top 2 Amount by item group = CA...
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
amitchandak
Super User
Super Useradmin_xlsior , Try like
Top 2 Amount by item group = CALCULATE(SUM(Transactions[amount]),
TOPN(2,
'Item groups', 'Item groups'[Group],ASC
), values('Item groups'[Group])
)
admin_xlsiorPost Prodigy
Post ProdigyHi amitchandak
Unfortunately, it's not working. Noticed on your video, it is coming from same table, is it the cause of it ?
Is TOPN only works on same table ?
Thanks,
- admin_xlsior
Sorry, it's not, on your video it is 2 tables, Item and Sales.
But still in my case it's not working, is it because mine is 3 tables ?
Thanks