Forum Discussion

JS's avatar
JS
Icon for Helper II rankHelper II
8 years ago

Concatenatex not returning desired string

I have an issue with my Concatenatex not returning my desired value. 

 

I have the following 3 measure

 

Sufficiency Level = IF([Total Line] > [FIN.Total Plan], "Sufficient", "Insufficient")

 

Insufficient Pipeline List = CONCATENATEX(FILTER(SUMMARIZE('Income Phase',Segment[Segment],"SC.Total Pipeline",[Total Line],"SC.Total Budget",[FIN.Total Plan]),[Sufficiency Level] = "Insufficient"),Segment[Segment],", ",Segment[Segment])

 

Insufficient Pipeline List = CONCATENATEX(FILTER(SUMMARIZE('Income Phase',Segment[Segment],"SC.Total Pipeline",[Total Line],"SC.Total Budget",[FIN.Total Plan]),[Sufficiency Level] = "Sufficient"),Segment[Segment],", ",Segment[Segment])

 

Basically this measure summarize the value and return the segment that falls under the insufficient level. 

 

 

 

Based on the image above, the measure did return and allocate the segment name correctly. But as observed at the first row, no results was returned. 

 

Why is this behaving this way? Is there anything wrong with the measures? 

 

Thanks.

 

Need Help

1 Reply

  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support
    8 years ago

    Hi JS

    It is werid, I use your formula and dataset as a test, but i can see the measure return values for the first row.

     

    measure =
CONCATENATEX (
    FILTER (
        SUMMARIZE (
            Sheet10,
            Sheet10[segment],
            "SC.Total Pipeline", [Total Line],
            "SC.Total Budget", [total plan]
        ),
        [Sufficiency Level] = "Insufficient"
    ),
    Sheet10[segment],
    ", ",
    Sheet10[segment]
)

    the only difference between my formula and yours is a different table name used in the SUMMARIZE function

    SUMMARIZE('Income Phase',Segment[Segment],

     

    Best Regards

    Maggie