Forum Discussion
qmartiny
Helper III
4 years agoIgnore 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
- amitchandak
Super User
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
Helper III
You again! Thank you so much
Have a great day 🙂