Unique count of values in one column based on if greater than in another column

[EricKautz]

I have a report that has a column of ID's that are replicated and another column that tells me the days past due for each. I need a distinct count IDs that are greater than 4 days. Below is my sample data. I just need the total counts so in this case, only 2 IDs would be past 4 days and the figure to display in the card is 2.

ID	Days Past Due
12345	10
12345	10
11111	3
22222	6
22222	6
22222	6

[Ritaf1983 · Accepted solution]

Hi @EricKautz 

You can use :

Up_to_4 = CALCULATE(DISTINCTCOUNT('Table'[ID]),'Table'[Days Past Due]>4)

Bbix is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[EricKautz]

This worked perfectly thank you.

[Ritaf1983]

Happy to help 🙂

[MNedix]

Hi,

There isn't too much data to work with, I assume that 111113 is the only one which is not past due date by 4 days.

If this is the case then you can do something like this:

Past Due Date = CALCULATE(DISTINCTCOUNT(Table[ID]),DATEADD('Date'[Date],-4,DAY)

If this solved your question then please mark it as the solution so others can see it. A Kodos would also be very much appreciated.

Best,

[EricKautz]

Sorry, I didn't realize Microsoft cut off some data when I posted. The numbers you are seeing are the ID's and the days combined. so for the ones that are 12345 days should be 10, 11111 should be 3 days, and 22222 should be 6 days.