Custom message in card visualization based on selected value

[Anonymous]

Hello,

I have the following table and i am trying to have a card visualization which displays all the text messages associated with a barcode when it is selected, otherwise, it should display "More than one barcode selected". Any help is much appreciated!

Barcode	Text message	Value
3998	closed line	215
4050	open and processing	189
4050	pending approval	214
4060	suspended	158
4139	open and awaiting	54
4145	open and awaiting	14
4149	open and awaiting	548
4157	open and awaiting	21
4160	pending approval	54
4160	pending approval	158
4164	pending approval	514
4166	pending approval	155
4187	suspended	187
4187	closed line	885
4187	open and processing	584
4187	closed line	879
4248	open and processing	931
4314	closed line	157
4474	open and processing	158
4481	open and processing	145
4487	pending approval	789
4495	suspended	652
4685	open and awaiting	365
4688	open and processing	144
4691	pending approval	15
4813	suspended	145
4832	open and awaiting	84
4997	open and processing	641

Here is the measure that i am currently using:

Barcode Selected Measure = 
IF (
    CALCULATE (
        HASONEVALUE ( 'My Table'[Text message] ),
        ALLSELECTED ( 'My Table' )
    )
        = TRUE (),
    SELECTEDVALUE ( 'My Table'[Text message] ),
    "More than one barcode selected"
)

Expected results:

1. when the barcode 3998 is selected from the table visualization, the card visualization displays the text: "closed line". This part is already working.

2. when the barcode 4050 is selected from the table visualization, the card visualization should display the text: "open and processing, pending approval". So, it should join all the text messages associated with that barcode. This part is not working. It currently shows "More than one barcode selected" which is wrong.

3. when more than one barcode is selected from the table visualization (i use ctrl+ to select multiple lines from the table), the card visualization displays the text: "More than one barcode selected". This part is already working.

[DataInsights · Accepted solution]

@Anonymous,

Try this measure:

Barcode Selected Measure = 
IF (
    NOT HASONEVALUE ( 'My Table'[Barcode] ), "More than one barcode selected",
    CONCATENATEX ( 'My Table', 'My Table'[Text message], ", " )
)

-----

-----