RankX issue converting to text with filters

[aucklanduser]

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 filters are applied to the table (as seen below), the rank and rank last month calculate correctly but when I put into a formula to get the Unichar arrow ('value' & " " & Unichar(9650)), the number is not showing correctly (see line one of the second table, showing as 1 with down arrow not 2 with down arrow). Rank minus rank LM is still calculating correct, when put into a formula with text it spits out an incorrect number when filtered.

Any ideas or happened before?

RankX issue

[aucklanduser]

Thanks for your help Parry, played around with filters and arrived at an acceptable solution

[aucklanduser]

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 · Accepted solution]

@aucklanduser change ALL to ALLSELECTED

[aucklanduser]

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

[aucklanduser]

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

[parry2k]

@aucklanduser can you share what your rank and other measures are ? 

[aucklanduser]

Measures below;

This month rank = RANKX(filter(ALL(BranchTable[branch]),BranchTable[Branch] <> "National sales"),[MTDGroupMargin%])

Last month rank = RANKX(filter(ALL(BranchTable[branch]),BranchTable[Branch] <> "National sales"),[MTDGroupMargin% LM])

Rank change calc = ([This month rank] - [Last month rank])*-1

Rank Change =

switch(

    true(),

    [Rank change calc] > 0, UNICHAR(9650) & " " & [Rank change calc],

    [Rank change calc] < 0, UNICHAR(9660) & " " & -[Rank change calc],

    [Rank change calc] = 0, "-"

)