dax formula gives inconsistent results across data sets

[Anonymous]

I am doing a simple rowcount across two related tables and am getting inconsistent results. 

In this first file I have paired the data set down to two IDs. In the Audit table I have 4 records for one ID and 5 records for the other. My "Record Count" custom column in the "Incidents" table calculates correctly. 

In this broken file, however I have loaded the full data set. The same 2 IDs from the first file have 4 and 5 records respectively, however it is calculating 5 records for both, even though one of them has 4. Any ideas why these are calculating incorrectly in the broken file?

[v-yulgu-msft · Accepted solution]

Hi @Anonymous,

By checking the Audit table in broken file, I found that there existing 5 records for both IDs.

Best regards,

Yuliana Gu

[Anonymous]

Thanks Yuliana. After reviewing it again I see that it was operator error. I wasn't looking at the data correctly. Thanks for your time!