Forum Discussion
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...
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?
itsmebvk , In summarize you can use
Fact and then dimension
Summarize(allselected(Fact), Dim[Dim1], Dim[Dim2])