HELP - A measure to rank the dynamic(filtered) dates column in Ascending order.

[Anonymous]

I have a column with start dates. I included an index (Rank) column starting from 1.

Let's say:

Start Dates:         Rank Column

a                                   1

b                                   2

c                                    3

d                                    4

e                                    5

After applying the filters:

The table looks like this:

Start Dates:         Rank Column

b                                   2

d                                   4

e                                   5

But I need :

Start Dates:         Rank Column

b                                   1

d                                   2

e                                   3

And I will be using that rank column to lookup the start date values in another If condition.

Any help will be appreciated.

THanks!

[MFelix]

Hi @Anonymous ,

Try to add the following measure:

Measure =
CALCULATE (
    COUNTROWS ( ALLSELECTED ( 'Table'[Start Date] ) );
    FILTER (
        ALLSELECTED ( 'Table'[Start Date] );
        'Table'[Start Date] <= MAX ( 'Table'[Start Date] )
    )
)

Should do the trick

Regards,

MFelix

[Anonymous]

Thanks for your reply!

But after applying your measure, I'm just not getting what I wanted.

Instead of getting 1 and 2, I'm gettign the original rank.

How do I remove duplicates in this?

For example, I have Jan - 2 four times in my start date. And everything is ranked the same number.

THanks,

Anand

[MFelix]

Hi @Anonymous ,

Based on my test with repeat dates in the the calculations are correct, what measure are you calculating?

Can you share a sample file?

Regards,

MFelix