Using Filter (or similar) with ConcatenateEx on Text Values

[tappingfoot]

I have the following dax measure in the value area of a pivot table to return a concatenated list of unique values from a table:

=CONCATENATEX(
    Values(
    Table1[Column2]
    ),
    Table1[Column2],", "
)

There are instances where 0 is returned as the value because no corresponding values exists for that row in the source data.

Is it possible to either replace with "-" or preferrably hide or filter out these rows entirely.

Any ideas?

 

[alansidman]

Here is the Syntax for using IF - then - Else in DAX

IF function (DAX) - DAX

Learn more about: IF

docs.microsoft.com

 

[tappingfoot]

Thanks for the help. I can't see to find out what type of value that 0 is.

DAX complains that i'm comparing text to a number is using 0. I tried the following, it appears to be value but doesn't have any affect:

=IF(ISTEXT((CONCATENATEX(
    Values(
    RawData[LCV to Remove]
    ),
    RawData[LCV to Remove],", "))),
CONCATENATEX(
    Values(
    RawData[LCV to Remove]
    ),
    RawData[LCV to Remove],", "),"-"    
)