Forum Discussion
Anonymous
3 years agoNot applicable
TOPN
Hi All, I'm very new to PowerBI, so not sure if this is even the location I need to post to. I'm having difficulty working with topN. I have to use topN for one of my charts but need it to asso...
amitchandak
3 years agoSuper User
Anonymous , You can use a visual level TOPN filter or create a TOPN measure
example
calculate([Net Sales PY], TOPN(2, allselected('Address'[Country ISO]), [Net Sales PY],desc), values('Address'[Country ISO]))
refer: TOPN: https://youtu.be/QIVEFp-QiOk
Others
Switch TOPN with Field Parameters: https://amitchandak.medium.com/switch-topn-with-field-parameters-299a0ae3725f
Power BI- Power BI- TOPN with Others- https://youtu.be/I_TY4hVlzAE