Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 = CALCULATE(SUM(Transactions[amount]),
TOPN(2,
'Item groups', 'Item groups'[Group],ASC
)
)
Whereby what I want to show is the TOP 2 item group, what is the mistake, because currently still all item group come out.
The value and the ranking is correct though, only it doesn;t only show 2 of my item group.
Thanks,
Solved! Go to Solution.
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
@admin_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])
)
refer: https://www.youtube.com/watch?v=QIVEFp-QiOk
Hi @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,
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |