Different count in power query and table view

[ReneeKoelewyn]

Hi,

I am struggling to do a count of responses in Power BI. The data seems to pull through correctly in Power Query, but not to my table and report view? 

For example, in Power Query the count for disagree is 6:

In table view I get 5, which then of course pulls through to my report view. 

When selecting 'agree' it should be 33, but 27 is calculated in the table view... 

Once I have corrected this and want to compare a previous year's results, would I simply do a count for that year next to this result?

I would realy apprecaite assistance. 

[amitchandak · Accepted solution]

@ReneeKoelewyn , You are showing the count of two different columns in Power Query Vs DAX.

Please check the same.

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[ReneeKoelewyn]

Thank you, I had a bit of a moment it seems... clearly a long day 🙂