Forum Discussion

Rubal's avatar
Rubal
Icon for Helper II rankHelper II
6 years ago
Solved

Help with a measure formula

Hi,    I have a measure which identifies the "Project Name", based on the "Project Priority Score" (the lowered the score is the highest priority).   Top Ranked Project v2= CALCULATE(SELECTEDVALU...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    6 years ago

    Hi Rubal ，

     

    I‘m not sure whether you wanna show as below?

    If so,just modify your measure as below:

     

    Top Ranked Project v2= CALCULATE(SELECTEDVALUE('PowerBi Data Export'[Project Name])&"-"&SELECTEDVALUE('PowerBi Data Export'[Status]),TOPN(1,ALLSELECTED('PowerBi Data Export'),'PowerBi Data Export'[Project Priority Score], ASC))

     

    If it is not what you need,show me your expected output.

    Much appreciated.

     

     
    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!