[ Create Index Auto with Measure ]

[phamtrinh96]

Hi , I have a problem and I need from your help. 

I have 1 slicer select Brands. when I select one or many Barnd then slicer table will show many restaurant of Barnd. And I want to create Index for restaurant

ex , I select Brand " A " , It show 4 restaurant 

Index   Restaurant_Name         Amount

1             KFC                              10000

2             BBQ                             15000

3             Xuxu                            24000

4             McDobal                      9000

[v-yuta-msft · Accepted solution]

@phamtrinh96 ,

You may create a measure using DAX like pattern below:

Index =
RANKX (
    ALLSELECTED ( Table[Brands] ),
    CALCULATE ( SUM ( Table[Amount] ) ),
    ,
    DESC,
    DENSE
)

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[phamtrinh96]

With column " Amount " is created with Measure.

[rocky09]

You can go to Query editor --> Add Column --> Add Index Column.

[phamtrinh96]

No , I want to create index auto with restaurants after I select brand. If Use Querry Editor , It show result failer