Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Concatenate Max Values

Hi everyone,  I have a table with Year, the provinces of the Netherlands and the substance in water. I want to show the province(s) with the highest amount of a substance per year.  This measur...
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    Anonymous , prefer topn

    concatenatex(Topn(1, allselected('Province'[Province]) , [Your Meausre], desc) , [Province])

     

    You can also consider index function

    Power BI Index function: Top/Bottom Performer by name and value- https://youtu.be/HPhzzCwe10U

     

    TOPN: https://youtu.be/QIVEFp-QiOk
    TOPN with Numeric Parameter -https://youtu.be/cN8AO3_vmlY?t=26448

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

Anonymous , prefer topn

concatenatex(Topn(1, allselected('Province'[Province]) , [Your Meausre], desc) , [Province])

 

You can also consider index function

Power BI Index function: Top/Bottom Performer by name and value- https://youtu.be/HPhzzCwe10U

 

TOPN: https://youtu.be/QIVEFp-QiOk
TOPN with Numeric Parameter -https://youtu.be/cN8AO3_vmlY?t=26448