Forum Discussion

qmartiny's avatar
qmartiny
Icon for Helper III rankHelper III
4 years ago
Solved

Ignore blank values in COMBINEVALUES

Hello lovely people,

 

I have the following DAX returning in a column all the combination from the following table

 

 

L4 = 
CONCATENATEX( RELATEDTABLE(ALL_IB_FILTER), ALL_IB_FILTER[Solution],"|")

 

 

 

I would like to clean up the output since the formula also combines empty values and leaves the delimiter

 

My expected output : only show combine values when not empty ex 

 

Sol 1 | Sol 2 | Sol 4

Sol 3 | Sol 2 | Sol 5

 

 

Thank you very much

 

Quentin

 

 

  • qmartiny , based on what I got, Try like 

     

     = 
    CONCATENATEX( filter(RELATEDTABLE(ALL_IB_FILTER), not(isblank(ALL_IB_FILTER[Solution]))) , ALL_IB_FILTER[Solution],"|")

     

2 Replies

  • qmartiny , based on what I got, Try like 

     

     = 
    CONCATENATEX( filter(RELATEDTABLE(ALL_IB_FILTER), not(isblank(ALL_IB_FILTER[Solution]))) , ALL_IB_FILTER[Solution],"|")

     

    • qmartiny's avatar
      qmartiny
      Icon for Helper III rankHelper III

      You again! Thank you so much

       

      Have a great day 🙂