Forum Discussion

naveedsaeed1's avatar
naveedsaeed1
New Member
3 years ago

DAX command with condition

Hello community team,   I am using below ConcatenateX formula for the purpose to join multiple values in pivot if there is any dual values for the same variable. =CONCATENATEX(DISTINCT(Table1[Mode...
johnt75's avatar
johnt75
Super User
3 years ago

You could use

My Measure =
CONCATENATEX (
    DISTINCT (
        FILTER ( ALLSELECTED ( Table1[Mode] ), NOT ISBLANK ( Table1[Mode] ) )
    ),
    Table1[Mode],
    ", "
)