I have had this happen on multiple occasions but I am not sure the cause.
I have a pivot based on a very large dataset (800k rows) and there are some number values but also some text strings, so I use CONCATENATEX to convert those to text so I can include them in the pivot table.
Sometimes when I create it then drag it to values, nothing happens. It processes then just nothing happens.
Is there a data size limit to how much this can handle or is there another known issue that could cause this?
Example of the customer measure:
The measure is right as far as I know, I always use this same formula, unless I am making a typo or something?
Thanks in advance!
Edit: I think I may have just fouled up the DAX, should be =CONCATENATEX(Values(Table1[CustomerName]), Table1[CustomerName], ", ")
Bookmarks