MULTI-ROW CARD NOT SHOWING ALL ASSOCIATED DATA FOR A ROW WITH MULTIPLE ENTRIES

Question

I am trying to use a multi-row card visual to show multiple characteristics of the same event (in my case, particular crime event). I want it to show the 1) Case Number, which ther will only be one; 2) Crime(s) There may be one or multiple crimes under one caxse number, and 3) Date, also only one.

I am having trouble displaying the Crimes field WHEN I HAVE MORE THAN 1 CRIME TO LIST FOR EACH CASE NUMBER. It only lets me show one crime associated if there are more than 1.

Is there a way I can show all the avaliable data points if there are multiple entries in a multi-row card visual?

anonymous · Accepted Answer

Hi&nbsp;ClackamasAshley&nbsp;,
As checked your screenshot, it actually display two times with different crime info for the case number&nbsp;22-000424...

&nbsp;
I created a sample pbix file(see the attachment), please check if that is what you want.
Method1: Create a measure as below to get the concatenate text of crime(s) per case
Crime(s) = 
CONCATENATEX (
    FILTER (
        'Table',
        'Table'[Case Number] = SELECTEDVALUE ( 'Table'[Case Number] )
    ),
    'Table'[Crime],
    UNICHAR(10),
    'Table'[Crime], ASC
)

Method2:&nbsp;&nbsp;1) Create a calculated column as below, then create matrix visual
Column = 
CONCATENATEX (
    FILTER ( 'Table', 'Table'[Case Number] = EARLIER ( 'Table'[Case Number] ) ),
    'Table'[Crime],
    UNICHAR ( 10 ),
    'Table'[Crime], ASC
)