Forum Discussion
Count not calculating correctly
It would be the same measure/formula. You would just use your date field in your visual or table as a column or x-axis. For this example, I used the same data you shared but changed a couple of the dates so that you can see the break of the count measure among dates.
Notice I used the same measure I shared, but now I pulled in the date column. This counts the number of "Promoter"s by date.
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?
