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.

     

CerebusBI's avatar
CerebusBI
Resolver I
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.

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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