Forum Discussion

michaeljc70's avatar
michaeljc70
Icon for Advocate II rankAdvocate II
10 years ago

Displaying top x with Rankx

So, I've searched and found several topics on getting the Top X using RankX.  However, I am not sure where/how to use this.  I am new to Power BI (SSRS background).     I am using a SQL Server quer...
Need Help
michaeljc70's avatar
michaeljc70
Icon for Advocate II rankAdvocate II
10 years ago

Thanks for the response.  

 

I did play around some more and discovered that I cannot use a custom formula because I am using DirectQuery.  It seems I have to incorporate the rankings in my query.  Please correct me if I am wrong.  

 

 

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
10 years ago

You are correct.