Forum Discussion
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 ...
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.
Anonymous , Visual have product_id as ungrouped column then only this will work
or simply product_id unsummarized