Forum Discussion
getting one extra blank row in the data when using count
FYI, there's also a function DISTINCTCOUNTNOBLANK.
Hi,
A few questions...
1) Have you written a measure to do the count or are just dropping the column into the visual ? If it's a measure can you share? If you're dropping column into visual I'm assuming you've checked what aggregation it is set to use? (Will normally default to Sum rather than count).
2) Is it possible a row looks blank but actually has something like a space in it?
3) Is it all just a single table or do you have relationships involved? If you do can you share a picture of your data model or even better the pbix file (or demo version of it)
Ben
1)its just measure with count function
2) i checked in the database and there's one value
3)theres no relationship with other tables and .
Do you want to strip any sensitive data out and send your pbix file. Nothing in your answers is jumping out as the cause! Will happily take a look.
The other thing to try is when you import in power query run Clean and then Trim on the column in question. Fairly sure there might be some hidden blank space. Worth ruling it out anyway.
using count instead of distinct count worked for me . distinct count considers the blank row however count doeant. will try to find out if theres any blank data also