Forum Discussion

aucklanduser's avatar
aucklanduser
Icon for Helper I rankHelper I
7 years ago
Solved

RankX issue converting to text with filters

Having an issue with RankX and filters. I have ranked my branches by margin %, then made a measure including a unichar and the value difference between Rank and Rank LM. The issue I have is when filt...
Need Help
aucklanduser's avatar
aucklanduser
Icon for Helper I rankHelper I
7 years ago

I'm thinking I can get around it by using summarised tables but I think I am going to end up doing this for at least 4 probably more categories so would prefer to keep it in measures

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    7 years ago

    aucklanduser change ALL to ALLSELECTED

    • aucklanduser's avatar
      aucklanduser
      Icon for Helper I rankHelper I
      7 years ago

      Thanks Parry, this solved my Filter statement which has now been removed, problem is still there unfortunately

    • aucklanduser's avatar
      aucklanduser
      Icon for Helper I rankHelper I
      7 years ago

      So it looks like the all selected is working (as the rank change new is the Rank this month minus Rank last month) however when I filter national sales out, something weird happens with Christchurch when filters are applied which makes me think that the all selected isnt working