Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |