Card Visualization using a Matrix and measure

[AA622]

Hello

So I have a card visualization that displays the "Account name" when selected in a matrix. But if you drill down the matrix also displays invoice number. FYI the matrix only has 2 rows; Account name and Invoice number.

Currently I have the card using this measure but it only works for the first row, Account name:

FlagsSelected = IF ( ISFILTERED ('Table'[AccountName]),
CONCATENATEX(ALLSELECTED(Table[AccountName]), Table[AccountName], ", ")
,
"No Account Selected"
)

It only works for Account name. If I drill down to invoice number and select a respective number it wont display in the card visualization.

How do I alter my measure to work for both in the matrix.

And If I add a 3rd 4th row potentially...

Thanks

[v-jingzhang · Accepted solution]

Hi @AA622 

Try this measure

FlagsSelected = 
SWITCH (
    TRUE (),
    ISFILTERED( 'Table'[InvoiceNumber] ),
        CONCATENATEX (
            ALLSELECTED ( 'Table'[InvoiceNumber] ),
            'Table'[InvoiceNumber],
            ", "
        ),
    ISFILTERED ( 'Table'[AccountName] ),
        CONCATENATEX (
            ALLSELECTED ( 'Table'[AccountName] ),
            'Table'[AccountName],
            ", "
        ),
    "No Account Selected"
)

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[lbendlin]

Extend your measure to check for the scope - ISINSCOPE can tell you where in the hierarchy you are.