Hi there,I am struggeling with the RankX function, I would like to see in how many countries different employees have worked, based on Month/Year, so I can filter on Month Year. As you can see in the picture I already tried a few things but it does not work out yet. First column is my employee, second the month year, country worked in, and in the last column named Country amount I need to see in how many countries someone have worked. So when the country changes it needs to add 1 to country amount. BUT when it changes back to Netherlands, it is not another country because he worked in that country before, it is not allowed to go from 2, to 3. But it needs to remain 2. Hope someone could help me.

Hi TK12345 ， I have updated your sample pbix file(see attachment), please check whether that is what you want. You can create a calculated column as below: New_Countries worked in = CALCULATE ( DISTINCTCOUNT ( 'Blad1'[Country-legal] ), FILTER ( ALLEXCEPT ( 'Blad1', 'Blad1'[Employee] ), 'Blad1'[Month/Year] <= EARLIER ( 'Blad1'[Month/Year] ) ) ) Best Regards

RANKX with repeated values | Microsoft Fabric Community

Forum Discussion

Related content

Bottom 10 considering repeated value.

RANKX excluding a value

RANKX with duplicate values

RankX

Rank/RankX For Multiple Columns With Repeating Values