RANKX working OBLY within a table

[DagmaraBI]

Hi Guys!

I have a small issue, but a real pain 🙂 

I have two tables:
FactSales - data about units sold

DimStore - stores in which this units are sold

I want to get THE BEST PERFORMING store, in which case I want to rank my stores based on Units sold.

I have prepared measure:

RankX by Store =

RANKX(

    ALL(DimStore[Store_Name]),

    SUM([Units])

    )

But its gets me wrong values. 

My model is really simple. 
DimStore[Store_Id] - FactSales[Store_Id]

        1            -                 many
  

[amitchandak · Accepted solution]

@DagmaraBI , if you create a rank on the store name and use storeId in visual, rank of store will get distributed inside store id 

Try like

Rank = RANKX(all(Dim_store),calculate(Sum(Table[Unit]) ) )

or

Rank = RANKX(all(Dim_store[Store_id],Dim_store[Store_name] ),calculate(Sum(Table[Unit]) ) )

explained here - https://www.youtube.com/watch?v=cN8AO3_vmlY&t=25627s

[DagmaraBI]

Tahnk you 🙂
You helped me very much 🙂 

I will subsribe your channel for more knowledge