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.
May I know any findings for this problem?
Case 1:
I have the same issue, checked there are only 41 rows in data, but after adding a relationship,
there is an extra row shown in Count() function,
It also shows a blank option in the filter pane with no record.
Case 2:
After applying and loading data in power query to power bi report,
both the report and data view show an extra blank record.
but there is no record found in the data source and power query editor (filtered with null, result = 0)
and no relationship was applied in the report.
Checked another report with the same data source but no extra blank row problem.