Forum Discussion

jalaomar's avatar
jalaomar
Icon for Helper IV rankHelper IV
3 years ago

Top N based on multiple conditions

Hello,

 

I have a tabel of all projects which has its projects health status in different areas.

i would like to display the Top 10 worst projects by checking if there are projects that has status red occuring once or more times.

 

any suggestion on how to make that happen?

 

 

Need Help

1 Reply

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

    jalaomar , you get that using topN measure

     

    TOP10 project= CALCULATE([Measure], TOPN(10,ALLSELECTED('Item'[project]), [Meausre],DESC), values('Item'[project]))

     

    or

    if(Max(Item[Project])  in TOPN(10,ALLSELECTED('Item'[project]), [Meausre],DESC) , "Green", "Red")