Forum Discussion

lawada's avatar
lawada
Icon for Helper III rankHelper III
4 years ago
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...
Need Help
Show and Tell
bcdobbs's avatar
bcdobbs
Icon for Community Champion rankCommunity Champion
4 years ago

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.

bcdobbs's avatar
bcdobbs
Icon for Community Champion rankCommunity Champion
4 years ago

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.

  • lawada's avatar
    lawada
    Icon for Helper III rankHelper III
    4 years ago

    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