Forum Discussion
Helper IIncorrect counts in Power BI (They are correct in the Query editor but wrong elsewhere)
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 )
Super Userbeckyconning 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
- 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?
- beckyconning
There it is! How fantastic. Power BI is really impressive.
- parry2kCheers. You got it.