Hi,
I have used the below measures in card to identify the top 1 to 5 project name.
However, I wish to add an if statement to return a 'Blank' as an output on the card if there is no 2nd /3rd/4th of 5th project. Currently, this measure is returning the same project name between 1 to 5 even if there are only one project. It returns blank if there is no project and it works fine if there are more than 5 projects to identify the top 1 to 5.
With the table below when I select the country like Australia, I do get the top 5 project name (Alpha, Gamma, Apollo, Narellan, Aquaone) based on their project priority score.
However, for Fiji, I get a return of Beta, Delta, Bluedog, Bluedog ( i wish to proceed with an output of Beta, Delta, Bluedog, Blank) and for New Zealand, it returns Vitafresh, Vitafresh, Vitafresh, Vitafresh, Vitafresh ( i wish to proceed with an output Vitafresh, Blank, Blank, Blank, Blank)
Top Ranked Project = CALCULATE(SELECTEDVALUE('PowerBi Data Export'[Project Name]),TOPN(1,ALLSELECTED('PowerBi Data Export'),'PowerBi Data Export'[Project Priority Score], ASC))
2nd Ranked Project = CALCULATE(SELECTEDVALUE('PowerBi Data Export'[Project Name]),TOPN(1,TOPN(2,ALLSELECTED('PowerBi Data Export'),'PowerBi Data Export'[Project Priority Score], ASC)))
3rd Ranked Project = CALCULATE(SELECTEDVALUE('PowerBi Data Export'[Project Name]),TOPN(1,TOPN(2,TOPN(3,ALLSELECTED('PowerBi Data Export'),'PowerBi Data Export'[Project Priority Score], ASC))))
4th Ranked Project = CALCULATE(SELECTEDVALUE('PowerBi Data Export'[Project Name]),TOPN(1,TOPN(2,TOPN(3,TOPN(4,ALLSELECTED('PowerBi Data Export'),'PowerBi Data Export'[Project Priority Score], ASC)))))
5th Ranked Project = CALCULATE(SELECTEDVALUE('PowerBi Data Export'[Project Name]),TOPN(1,TOPN(2,TOPN(3,TOPN(4,TOPN(5,ALLSELECTED('PowerBi Data Export'),'PowerBi Data Export'[Project Priority Score], ASC))))))
| Project Name | Project Priority Score | Country |
| Project Alpha | 1 | Australia |
| Project Beta | 2 | Fiji |
| Project Gamma | 3 | Australia |
| Project Delta | 4 | Fiji |
| Project Apollo | 5 | Australia |
| Project Bluedog | 6 | Fiji |
| Project Narellan | 7 | Australia |
| Project Vitafresh | 8 | New Zealand |
| Project Aquaone | 9 | Australia |
I am not sure if an if statement is the right way to go. I am happy to explorer other option as well to make this work.
Appreciate your help on this.
