hello all,I have been stuck on something for a while. Your help would be appreciated.My data model is simple with one user dimention table and on fact tale holds the qty of user.There are slicers for choose group and age.I created a measure to show Rank of selected user's qty as below and it went well:Rank_Qty =RANKX(ALLSELECTED('Dim'),CALCULATE(sum('Fact'[Qty])))But if I created anthor page(page2) to be the drill down target visual to show the drilled user's detail information,Rank_Qty will always be 1 for each drilled user, is there any method to keep the rank value of each user but 1? Thanks in advance

hi this isn't hugely clear what you are trying to say, please provide examples of the data you using so that the right help can be given, screenshots, and clear concise information will help in getting the right answer to you.

vanessafvgthank you for your reponse.I created a report as below.Rank is went well in Page1:But if I drill down the user '000000000000000001' to page2 in where I want to show the detail information of user '000000000000000001' included the Rank_Qty(7):The Rank_Qty will always be 1:I don't want the Rank_Qty in page2 to be shown as 1 but the correct value in page 1.Is there any solution? Thank you very much

Anonymous , Rank measure is very specific to the context. So on-page to 2 are you taking values from other table like age and group. then it might not work Otherwise, try to include all such column into all Like Rankx(all(column1,column2,column3),[Measure]) For Rank Refer these linkshttps://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measureshttps://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columnshttps://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finalehttps://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/367415

Dear amitchandak Thank you for your response.I knew the reason Rank_Qty shows in pase 2 is always being 0 is the context filter that filtered only one users out.And I also tried below:1)Rankx(all(dim[user]),[Measure])->don't work because it only ignored context filter of user but context filter of group&age.It generates result likeselect user,rank from dim where group in (xx,xxx) and age in (yy,yyy) group by user,group,age2)Rankx(all(dim[user],dim[group],dim[age]),[Measure])->don't work because it ignored all context filter of user&group&age,and it also ignore the slicers selection of group&age.It generates result likeselect user,rank from dim group by user What I want is the result likeselect user,rank from dim where group in (xx,xxx) and age in (yy,yyy) group by user Could you have any ideas?

Anonymous , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Rankx value changed when drill down | Microsoft Fabric Community

21 Replies

vanessafvg
Community Champion
6 years ago
hi this isn't hugely clear what you are trying to say, please provide examples of the data you using so that the right help can be given, screenshots, and clear concise information will help in getting the right answer to you.
- Anonymous
  Not applicable
  6 years ago
  vanessafvg
  thank you for your reponse.
  I created a report as below.
  Rank is went well in Page1:
  But if I drill down the user '000000000000000001' to page2 in where I want to show the detail information of user '000000000000000001' included the Rank_Qty(7):
  The Rank_Qty will always be 1:
  I don't want the Rank_Qty in page2 to be shown as 1 but the correct value in page 1.
  Is there any solution?
  
  Thank you very much
  - amitchandak
    Super User
    6 years ago
    Anonymous , Rank measure is very specific to the context. So on-page to 2 are you taking values from other table like age and group. then it might not work
    
    Otherwise, try to include all such column into all
    
    Like Rankx(all(column1,column2,column3),[Measure])
    
    For Rank Refer these links
    https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
    https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
    https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale
    https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/367415

Forum Discussion

Rankx value changed when drill down

21 Replies

Related content

RANKX excluding a value

RankX

RANKX with duplicate values

RANKX Function considering slicer value

Rankx Value