Forum Discussion
DAX To Split Measure Text into Separate Rows
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.
Hi Anonymous ,
Your problem sounds interesting, but I'm not sure that I understand it correctly:
According to your measure, you have a table "Data" with a column "product_id". And your measure refers to it.
In the end, you want to create a column with product IDs.
Why do you use the measure at all?
Why don't you just filter on the given column with the product_id?
I'm sure, I'm misunderstanding something here.
Please give me a hint.
Hi CerebusBI ,
I don't think I was as clear as I thought I was, sorry! Basically, I have a slicer for product id, and I'd like to be able to have whichever values are selected in this slicer as separate rows in a measure. This formula:
CONCATENATEX ( VALUES ( Data[product_id] ) , [product_id] , ",")
gets me halfway there, as it shows the product IDs selected in the slicer, but all in one row, which makes using this data difficult.
I this makes it a bit clearer, and thanks for you help!
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.
CerebusBI Ah ok, I was worried that might be the case. I'll go back to the drawing board and see if I can design what I need differently. Thanks so much for your help