Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

DAX To Split Measure Text into Separate Rows

Hi,   I'm having trouble writing DAX to perform what I need. I have a measure that creates a list of the values selected from a filter for a product ID:     Filtered Product IDs = CONCATENATEX ...
DAX
Power BI Desktop
  • CerebusBI's avatar
    CerebusBI
    4 years ago

    Hi Anonymous ,

     

    A measure always needs to have a scalar result: A number, a text, a date...

    but never a table or a list.

     

    I agree with OwenAuger: maybe we need to understand what's your raw data and what you want to see in your report / visual.

     

    Could it be possible that putting the raw Data[product_id] into the Slicer and also into the table column?

    Then choosing some Ids in the slicer would also filter the table accordingly.

     

OwenAuger's avatar
OwenAuger
Super User
4 years ago

Hi Anonymous 

You can use the "Line feed" character UNICHAR(10) if you require text split across multiple lines.

I recall in the past that line feeds didn't always display correctly, but they appear to work now for values within card and table visuals at least.

 

Sample measure:

Filtered Product IDs =
CONCATENATEX (
    VALUES ( Data[product_id] ),
    Data[product_id],
    "," & UNICHAR ( 10 )
)

 Regards,

Owen