Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

USING CONCATENATEX IN A DYNAMIC TITLE FOR MULTIPLE SLICERS

So I have a dynamic title which concatenates values which are selected from a slicer. If no slicer is selected, the title is blank.  However - my DAX measure only accounts for a single slicer being ...
Need Help
  • parry2k's avatar
    parry2k
    4 years ago

    Anonymous if you have formatted the code correctly you could have figured it out. You were almost there:

     

    FILTERED TITLE =
IF (
    ISFILTERED ( 'REVIEWS'[UNDERWRITER] )
        || ISFILTERED ( 'REVIEWS'[NEW BUSINESS/RENEWAL] )
        || ISFILTERED ( 'REVIEWS'[CLAIM BASIS] )
        || ISFILTERED ( 'REVIEWS'[REGION] ),
    "ERROR SPLIT FOR - "
        & CONCATENATEX ( VALUES ( 'REVIEWS'[UNDERWRITER] ), 'REVIEWS'[UNDERWRITER], ", " )
        & CONCATENATEX (
            VALUES ( 'REVIEWS'[NEW BUSINESS/RENEWAL] ),
            'REVIEWS'[NEW BUSINESS/RENEWAL],
            ", "
        )
        & CONCATENATEX ( VALUES ( 'REVIEWS'[CLAIM BASIS] ), 'REVIEWS'[CLAIM BASIS], ", " )
        & CONCATENATEX ( VALUES ( 'REVIEWS'[REGION] ), 'REVIEWS'[REGION], ", ", "" )
)

     

     

     

    ✨ Follow us on LinkedIn and  to our YouTube channel

     

    Check my latest video on Filters and Sparklines https://youtu.be/wmwcX8HvNxc

     

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

     

    ⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.

parry2k's avatar
parry2k
Icon for Super User rankSuper User
4 years ago

Anonymous if you have formatted the code correctly you could have figured it out. You were almost there:

 

FILTERED TITLE =
IF (
    ISFILTERED ( 'REVIEWS'[UNDERWRITER] )
        || ISFILTERED ( 'REVIEWS'[NEW BUSINESS/RENEWAL] )
        || ISFILTERED ( 'REVIEWS'[CLAIM BASIS] )
        || ISFILTERED ( 'REVIEWS'[REGION] ),
    "ERROR SPLIT FOR - "
        & CONCATENATEX ( VALUES ( 'REVIEWS'[UNDERWRITER] ), 'REVIEWS'[UNDERWRITER], ", " )
        & CONCATENATEX (
            VALUES ( 'REVIEWS'[NEW BUSINESS/RENEWAL] ),
            'REVIEWS'[NEW BUSINESS/RENEWAL],
            ", "
        )
        & CONCATENATEX ( VALUES ( 'REVIEWS'[CLAIM BASIS] ), 'REVIEWS'[CLAIM BASIS], ", " )
        & CONCATENATEX ( VALUES ( 'REVIEWS'[REGION] ), 'REVIEWS'[REGION], ", ", "" )
)

 

 

 

✨ Follow us on LinkedIn and  to our YouTube channel

 

Check my latest video on Filters and Sparklines https://youtu.be/wmwcX8HvNxc

 

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

 

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

parry2k yes you're totally right. I see what I did wrong. I should have laid it out as you had, then I would have reaslised. 
What I have discovered now though, is that even if you select a single slicer, the measure is displaying every single option available from all the other slicers. For example if I select a region, the measure displays that region, plus all the underwriters that fall under that region - even if I haven't filtered 'UNDERWRITER'. It's a hot mess. Is there any way to tell the measure to only display the results that have been selected? 

I tried changing my measure to 'ISCROSSFILTERED' but that doesn't affect the result.