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

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