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; Acc...
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.

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.