Copy a text column in new measure.

[mansiluthra12]

Hi Everyone , 
I am trying to create a new measure with same value as of one text column. I have tried with

CONCATENATE, CONCATENATEX,SUMMARIZE but nothing works as it gives "error Message: Memory error: While attempting to store a string, a string was found that was larger than the page size selected. The operation cannot be completed." message as it's a live connection.
Is there any way to copy text columns values same in measure with the help of dax.

[VahidDM]

Hi @mansiluthra12 

If that is the Memory issue, and you are using Power BI Desktop, try increasing the Maximum allowed to 16000 under File / Options and Settings / Options / Global / Data Load.  Data Cache Management Options.

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!!

[mansiluthra12]

I tried increasing this but still same error message , I have around 57K records in my table

[Pragati11]

Hi @mansiluthra12 ,

I am not clear on what you are refrerring here to getting text values from a column.

My understanding is you are looking to get all the row-values from a column in a measure concatenated somehow.

If that is the case then consider following scenario. I have a text column as follows:

Now I want to get all the text values from Category column concatenated in a measure. The same values are repeated multiple times in a column. A measure can be written as follows:

concatCategory =
CONCATENATEX ( ClothingSales, ClothingSales[Category], "," )

And this will give you following output:

Let me know if this is what you are looking for.

Thanks,

Pragati

[mansiluthra12]

I tried with CONCATENATEX and that gives me same error msg mentioned above. 
Basically what I am trying to do is - I have a text column having URL links . I need to use that in my dashboard , but for url icon , I need that field to be in web url datacategory.  As, my datasource is analysis service cube , I can neither modify anything exsiting nor can create custom columns . the only thing I can do is create a measure and then modify its datatype.