Forum Discussion

AA622's avatar
AA622
Helper II
4 years ago
Solved

Card Visualization using a Matrix and measure

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

Need Help
  • v-jingzhang's avatar
    v-jingzhang
    4 years ago

    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.

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

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

  • v-jingzhang's avatar
    v-jingzhang
    Community Support
    4 years ago

    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.