Forum Discussion

jkernen's avatar
jkernen
Frequent Visitor
5 years ago

RANKX, PROBLEM WITH FILTER FROM OTHER TABLE

Im using the following measure:
 
rank= RANKX(ALLSELECTED(T1), sumx(RELATEDTABLE(T1),[K1]))
 
as a dynamic ranking column in a visual table.
 
Wich works, until I filter on another table (T2).
 
Then the filtering gets corrupted. So I get more rows (with empty cells, that shouldnt be there at all), when I add the measure "rank", to the visual.
 
Any solutions?
 
 
ALLSELECTED
crossfilter
Filter
ranking
RANKX
relatedtable

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

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