Incorrect counts in Power BI (They are correct in the Query editor but wrong elsewhere)

[beckyconning]

I've checked the count in Snowflake and Postgres and the count is correct in the Query Editor but wrong in the tables and charts.

It should be 61 but it says 63.

[parry2k]

@beckyconning may be there are two rows for drugs and reaction which is making the sum of that count. if you drop down arrow next to count column in values section and choose don't aggregate, see what you get.

[beckyconning]

Thanks for your reply.

I still get the same incorrect value.

[beckyconning]

There it is! How fantastic. Power BI is really impressive.

[parry2k]

Cheers. You got it.

[beckyconning]

> That will not a make difference because fax calculations are not case sensitive although power query is

[parry2k]

@beckyconning as i can see in the screen shot, you count says, sum of count, you have click arrow next to it, and select Don' t Aggregate

[beckyconning]

Oh I see! Thank you.

Why is it coming up at 63 when it is set to sum of aggregate? There aren't any other rows with the same drugs and reaction?

[parry2k · Accepted solution]

@beckyconning there must be,

if you add following measure and then drop drug and reaction and this measure in a table, sort it by this measure you will see if there is count more than 1

CountRows = COUNTROWS ( myTable )

[beckyconning]

Oh! Perhaps there are some with different capitalisation and that capitalisation is being ignored. I'll try uppercasing everything in the query editor and try again.

[parry2k]

That will not a make difference because fax calculations are not case sensitive although power query is