Forum Discussion

itsmebvk's avatar
itsmebvk
Continued Contributor
4 years ago

Ranking Based Background Color not Working?

  Hi Folks,   We have a requirement to highlight top three ranking cells based on based on sales value ranking, it should update based on slicers selections too. Example : If i select different st...
Need Help
Tips and Tricks
amitchandak's avatar
amitchandak
Super User
4 years ago

itsmebvk , Rank in power Bi depends on what has been used. Like if used Part and you add any other column in row/column that part would be ranked inside that

 

Rankx(allselected(Table[Part]), [measure],,desc,dense)

 

when needing more columns you need to rank like

Rankx(Summarize(allselected(Table), Table[Part], Table[Company]) , [measure],,desc,dense)

 

Or switch between Ranks, Using isinscope

https://docs.microsoft.com/en-us/dax/isinscope-function-dax

  • itsmebvk's avatar
    itsmebvk
    Continued Contributor
    4 years ago

    amitchandak  

     

    Thanks for quick reply.

     

    can we use following expressions when we multiple tables columns inthe matrix and also we have many slicer from different tables?

     

    Rankx(Summarize(allselected(Table), Table[Part], Table[Company]) , [measure],,desc,dense)


    if not is there any alternative way to avoid virtual table and create a ranking using Dax?

    • amitchandak's avatar
      amitchandak
      Super User
      4 years ago

      itsmebvk , In summarize you can use

       

      Fact and then dimension

      Summarize(allselected(Fact), Dim[Dim1], Dim[Dim2])