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.
Hi,
Can you please help me with something?
I have a table that includes the following columns:
1) Tickets ID
2) Created Time
3) Account
I need to calculate the top 10 customers who raise tickets.
Since they are all in one table - I just tried to use the Top10 feature from the visuals pane filters and it did not work - its showing more than 15 accounts. I tried using the TOPN function - it says "Multiple columns cannot be converted to a scalar value."
(i.e) TOP10Accounts = TOPN(10, 'All Tickets', 'All Tickets'[Account],ASC)
Can you please help?
Solved! Go to Solution.
@Anonymous , Create two measures like and check
CntAccounts = count('All Tickets'[Account])
Top 10 City Rank = CALCULATE([CntAccounts],TOPN(10,all('All Tickets'[Account]),[CntAccounts],DESC),VALUES('All Tickets'[Account]))
refer to my video : https://www.youtube.com/watch?v=QIVEFp-QiOk
@amitchandak Thank you so much. This worked like a charm. I will try it on my other visuals too to see if it works on all scenarios. The video is very good too!
@Anonymous , Create two measures like and check
CntAccounts = count('All Tickets'[Account])
Top 10 City Rank = CALCULATE([CntAccounts],TOPN(10,all('All Tickets'[Account]),[CntAccounts],DESC),VALUES('All Tickets'[Account]))
refer to my video : https://www.youtube.com/watch?v=QIVEFp-QiOk
Hi Amitchandak
Thank you for the video, any chance that you can explain what "VALUES('All Tickets'[Account])" does at the end. I saw your reply in youtube comments, but still don't get it. Any chance you could elebrate more?
Thanks
Charles
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 |
---|---|
107 | |
98 | |
78 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |