Forum Discussion
darapowerbi
3 years agoFrequent Visitor
undefined
I want to percentages under each month value of top 5 clients.pls help
1 Reply
- amitchandakSuper User
Assuming visual is displayed on month
Divide( sumx(keepfilters(TOPN(5, allselected(client[Client]), [Measure], desc)) , [Measure]) , [Measure])
Learn Power BI: Dynamic TOPN using TOPN/Window and Numeric parameter: https://youtu.be/vm2mdEioQPQ
YouTube Podcast of all my videos (10+) on Offset, Window, and Index functions. Hope you will like that: https://www.youtube.com/watch?v=GpoITi_tRIw&list=PLPaNVDMhUXGax-j-mEF8ZxL5eV-VcmdvJ&index=5