Forum Discussion
Solved
getting one extra blank row in the data when using count
i have a table that shows : laundry name, order id, and rating id . for one laundry I'm getting one extra blank row for the rating , for example: one laundry has total orders =6 and total ratings =1...
FYI, there's also a function DISTINCTCOUNTNOBLANK.
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
FYI, there's also a function DISTINCTCOUNTNOBLANK.
