LinkedIn
Twitter
Maybe I am missing some point. May I know if anybody else is observing this?
I am getting inconsistent results in the list creation expressions like Table Name[Column Name] . When the column in the list is empty for all the table rows, even then it computes an inconsistent count with expressions such as COUNT(Table Name[Column Name]) and ISBLANK(Table Name[Column Name]) etc.
For an empty column, it still counts as 2
[Count_Suburb_List] has an expression of COUNT(Customers[Suburb]) and [Suburb_List] has an expression of Customers[Suburb]
Detail view:
Backend table with all 4 rows empty for [Suburb] column
Thank you very much Marc for testing. I was testing these expressions in a virtual column. On form save, the expression seems to give inconsistent results. The column separator is standard comma.
In the below case, there is only one row populated but the count is 2 in a table with 4 rows.
Edit: corrected the typo columns with rows.
Edit: Also my bad that I mentioned I am testing these in real column, I am testing these in VCs only like you.
