Forum Discussion

Br1-981's avatar
Br1-981
Helper I
3 years ago
Solved

Card with multiple values

Hi, I need to create a card including multiple values for a given category. Let's assume I have a table like this: Plate Brand Status 123456 Audi Good 111111 VW Poor 222222 BMW ...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Br1-981 ，

     

    Please try this measure.

    Measure = CONCATENATEX(DISTINCT('Table'[Status]),'Table'[Status],"-")

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Br1-981 ，

 

If you need to de-duplicate the status field, try this measure.

Measure = CONCATENATEX(CALCULATETABLE(VALUES('Table'[Status])),'Table'[Status],",",'Table'[Status],ASC)

Best Regards,
Gao
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

  • Br1-981's avatar
    Br1-981
    Helper I
    3 years ago

    Thanks,

    In the meantime I used the

    CONCATENATEX (
            ALLSELECTED (CampaignData[Social - Format (Video/Static)]), CampaignData[Social - Format (Video/Static)],
            " - "

    The problem is that is not considering unique values:

    Is there a way to have unique values?

    Cheers

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi Br1-981 ，

       

      Please try this measure.

      Measure = CONCATENATEX(DISTINCT('Table'[Status]),'Table'[Status],"-")

      Best Regards,
      Gao
      Community Support Team

       

      If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

      How to get your questions answered quickly --  How to provide sample data in the Power BI Forum