Forum Discussion

Nerf_Herder's avatar
Nerf_Herder
Frequent Visitor
3 years ago
Solved

Card Visual (DAX) with two Slicers

Hi Everyone,   I'm after some help with slicers.    I have two slicers: 'Customer' & 'Subscription'. I have a Card visual which displays the Customer name(s) selected in the Customer slicer. Wha...
Need Help
  • MohammadLoran25's avatar
    MohammadLoran25
    3 years ago

    Nerf_Herder 

    If I understood right, You need sth like this using SWITCH to handle different cases:

     

     

    SWITCH (
    TRUE (),
    NOT ( ISFILTERED ( 'Table'[Subscription] ) )
        && NOT ( ISFILTERED ( 'Table'[CustomerName] ) ), "All Customers",
    HASONEVALUE ( 'Table'[Subscription] )
        && NOT ( ISFILTERED ( 'Table'[CustomerName] ) ), VALUES ( 'Table'[CustomerName] ),
    HASONEVALUE ( 'Table'[CustomerName] )
        && NOT ( ISFILTERED ( 'Table'[Subscription] ) ), VALUES ( 'Table'[CustomerName] ),
    ISFILTERED ( 'Table'[Subscription] )
        && HASONEVALUE ( 'Table'[Subscription] ) = FALSE (), CONCATENATEX ( VALUES ( 'Table'[CustomerName] ), 'Table'[CustomerName], ", " ),
    ISFILTERED ( 'Table'[CustomerName] )
        && HASONEVALUE ( 'Table'[CustomerName] ) = FALSE (), CONCATENATEX ( VALUES ( 'Table'[CustomerName] ), 'Table'[CustomerName], ", " ),
    CONCATENATEX ( VALUES ( 'Table'[CustomerName] ), 'Table'[CustomerName], ", " )
)

     

     

    Now the logic is clear. Based on your need you can edit it easily.

     

    It helped? Mark it as an accepted solution.
    Regards,
    Loran

MohammadLoran25's avatar
MohammadLoran25
Solution Sage
3 years ago

Nerf_Herder 

If I understood right, You need sth like this using SWITCH to handle different cases:

 

 

SWITCH (
    TRUE (),
    NOT ( ISFILTERED ( 'Table'[Subscription] ) )
        && NOT ( ISFILTERED ( 'Table'[CustomerName] ) ), "All Customers",
    HASONEVALUE ( 'Table'[Subscription] )
        && NOT ( ISFILTERED ( 'Table'[CustomerName] ) ), VALUES ( 'Table'[CustomerName] ),
    HASONEVALUE ( 'Table'[CustomerName] )
        && NOT ( ISFILTERED ( 'Table'[Subscription] ) ), VALUES ( 'Table'[CustomerName] ),
    ISFILTERED ( 'Table'[Subscription] )
        && HASONEVALUE ( 'Table'[Subscription] ) = FALSE (), CONCATENATEX ( VALUES ( 'Table'[CustomerName] ), 'Table'[CustomerName], ", " ),
    ISFILTERED ( 'Table'[CustomerName] )
        && HASONEVALUE ( 'Table'[CustomerName] ) = FALSE (), CONCATENATEX ( VALUES ( 'Table'[CustomerName] ), 'Table'[CustomerName], ", " ),
    CONCATENATEX ( VALUES ( 'Table'[CustomerName] ), 'Table'[CustomerName], ", " )
)

 

 

Now the logic is clear. Based on your need you can edit it easily.

 

It helped? Mark it as an accepted solution.
Regards,
Loran

Nerf_Herder's avatar
Nerf_Herder
Frequent Visitor
3 years ago

MohammadLoran25,

 

Wow! Honestly that's amazing! I can't thank you enough. That worked exactly as I want it to!

 

Thank you!!

Ian.