Dynamic ranking

[Anonymous]

Hi All,

Please help me on dynamic Ranking in Column Not in Measure.....

i have created the rank column by brand wise and i applied any filters the rank is not comeing correctly . i am useing formula for rank in column=

Rankall Rows Groupby Brand =

RANKX(FILTER(ALLSELECTED(Sheet1),Sheet1[brand_id]=EARLIER(Sheet1[brand_id])),Sheet1[Index],Sheet1[Index].can you please help me on this.. 

how to create the dynamic ranking in columns not in Measure.. 

Orginalapplying filter as gender and brandwith applying filter as brand

[v-juanli-msft]

Hi @Anonymous 

Create measures

Measure = SUM(Sheet6[Index])

Measure 2 = 
RANKX(FILTER(ALLSELECTED(Sheet6),[Brand]=MAX(Sheet6[Brand])),[Measure],,DESC)

Best Regards

Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi,, thank you for your quick reply

but i need to create the same thing in calculated columns not in measures. if its possible to create the same thing in calculated columns????

Because i need to use the calculated column in matrix visual columns... Measures we can not used in the columns..

 please help me on this issuse......

[v-juanli-msft]

Hi @Anonymous 

It is impossible for a calcuated column to change dynamic based on selection.

Best Regards

Maggie