Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Custom message in card visualization based on selected value

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 ...
Need Help
  • DataInsights's avatar
    DataInsights
    4 years ago

    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], ", " )
)

     

    -----

     

    -----

     

DataInsights's avatar
DataInsights
Super User
4 years ago

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], ", " )
)

 

-----

 

-----