Forum Discussion
Count not calculating correctly
I am trying to count text in a column but I'm getting incorrect values. Example: I have two columns Visit Date Attendance Promoter-Detractor 7/9/2023 0:00 Promoter 7/9/2023 0:00 Pr...
Del235 Did this resolve your issue?
No. Something else is going on. Even if I do a count on the column Promoter-Detractor I dont get the same answer as I would if I export the data into excel.
If I export the Data Table to Excel, then import it into power bi, I get different results. See below:
The one on the left is correct. Both tables have the the column Promotor-Detractor as text. Why the different results?
Will you share a copy of the example pbix file you're working with?
It has PII info in it, and I'm using DirectQuery. I'll see if I can do it another way.