Forum Discussion
Calculated table - rows not showing
Thanks for all the replies.
I have solved the problem this time, but still don't completely understand it:
v-ljerr-msft, I checked the DISTINCT function with the other columns in the same table and found that it worked with all the columns that did not have blank or null values. For the columns that did have blank or null values (including the RegionName column), it displayed the table without showing the rows, but showed the number of rows at the bottom.
Solution: I filtered out the blank values in the RegionName column and it worked fine after that.
IMO this should be reported as a bug. Blank (and sometimes NULL) are valid data values, and we should be able to see the results without having to create a table visual in the report pane.
dedelman_clng bullius it's not a bug; you're just using the wrong formula if you want to include null as a valid value. If you want to return null as a value in a table like this, use NewTable = VALUES(TableName[ColumnName]) or NewTable = SUMMARIZE(TableName, TableName[ColumnName]). Read the notes on the differences between VALUES and DISTINCT to understand why. https://msdn.microsoft.com/en-us/library/ee634943.aspx
Thanks Anonymous,
I did test these functions as well. The results were the same:
Also, this isn't normally the result you get when you try to use the DISTINCT function with blank values is it?
The interesting thing is that it gives the number of rows at the bottom, as if it has successfully created the table. It also displays the unique vales if I create a table visualisation, including the blank value.
I would just leave it, but when I try to create a relationship between this table and the vwCompanies table, it says that neither table has unique values in the RegionName column.
As I said, I have solved it for this time, but I might flag it as a bug as well (althouigh I am not totally convinced that it is a sofware issue).