cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
phamtrinh96 Regular Visitor
Regular Visitor

[ Create Index Auto with Measure ]

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

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: [ Create Index Auto with Measure ]

@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.

4 REPLIES 4
phamtrinh96 Regular Visitor
Regular Visitor

Re: [ Create Index Auto with Measure ]

With column " Amount " is created with Measure.

rocky09 Senior Member
Senior Member

Re: [ Create Index Auto with Measure ]

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

 

 

phamtrinh96 Regular Visitor
Regular Visitor

Re: [ Create Index Auto with Measure ]

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

Community Support Team
Community Support Team

Re: [ Create Index Auto with Measure ]

@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.