Forum Discussion
Helper IIncorrect counts in Power BI (They are correct in the Query editor but wrong elsewhere)
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.
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 )
10 Replies
- parry2k
Super User
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.
beckyconningThanks for your reply.
I still get the same incorrect value.
- 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