Forum Discussion

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

DAX Measure: Filter in concatenatex

Hi, I'd like to filter the concatenated column value in the DAX statement with CONCATENATEX, in this example: Only Assignments with Relevant = Y should be shown for each account. So in the e...
Need Help
Show and Tell
Tips and Tricks
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi thhmez7 
    Please try 

    Assignment Measure =
VAR FilteredTable =
    FILTER ( Assignm, Assignm[Relevant] = "Y" )
VAR Result =
    CONCATENATEX (
        FilteredTable,
        Assignm[Assignment],
        ";" & UNICHAR ( 10 ),
        Assignm[Assignment], ASC
    )
RETURN
    Result
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Hi thhmez7 
Please try 

Assignment Measure =
VAR FilteredTable =
    FILTER ( Assignm, Assignm[Relevant] = "Y" )
VAR Result =
    CONCATENATEX (
        FilteredTable,
        Assignm[Assignment],
        ";" & UNICHAR ( 10 ),
        Assignm[Assignment], ASC
    )
RETURN
    Result
thhmez7's avatar
thhmez7
Icon for Helper III rankHelper III
4 years ago

Thank you, it works.