Measure showing incorrect value in row of table but total is correct

[Hayleysea]

Hi there, I have a measure as per below which counts ID's as at the earliest date (I have a date filter on my report set to on or after a certain date).

Original ID Count =

VAR __PreviousDate = MIN([Date])

Return

CALCULATE(COUNTA(table[ID]), FILTER(table, [Date]=__PreviousDate))

I then use this measure in a table but there is an extra 1 in one of the rows which shouldn't be there. The total is correct (it excludes the 1) as per below

ID	Count
A	1
B	5
C	7
Total:	12

As you can see above, ID 'A' has a count of 1 which isn't correct (it should be 0) but the total = 12 which is correct (5+7). How do I get rid of this random 1?

Any help appreciated 🙂

[Anonymous]

Hi @Hayleysea ,

I did some test but didn't meet the same scenario. Can you share some sample data to us?

Best Regards,

Jay

[amitchandak]

@Hayleysea , Try like

Original ID Count =
VAR __PreviousDate = MINX(Table, Table[Date])
Return
CALCULATE(COUNTA(table[ID]), FILTER(table, Table[Date]=__PreviousDate))

or

Original ID Count =
VAR __PreviousDate = MINX(Table, Table[Date])
Return
CALCULATE(COUNTA(table[ID]), FILTER(all(table), Table[Date]=__PreviousDate))

[VijayP]

@Hayleysea 

The Problem Statement is not Clear. As per my understanding created a File use this 

https://drive.google.com/file/d/1Y24Xxh7_TZDR-PJKnt6eb4UW0ExR5xsG/view?usp=sharing

This is what I have used and used IF condition as well 

Count =

VAR PD = MIN('DAte Table'[Date])

RETURN

CALCULATE(COUNT('Table'[ID]),FILTER(ALL('DAte Table'),'DAte Table'[Date]=pd))