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])