Dynamic title based on two slicers

[hejszyszky]

Hi,
I've managed to build a dynamic title based on 1 slicer. I'd like to change the code in order to include same rules with second slicer.

S1 = "PR % Impact by TOP10 Losses on "
&
IF(
    NOT(
        ISFILTERED(
            'Summarized Raport'[Name])),
            "Plant",
            IF(
                ISFILTERED('Summarized Raport'[Name]),
                CONCATENATEX(
                    values(
                        'Summarized Raport'[Name]),'Summarized Raport'[Name],",")
                        )
                        )

So - if i use slicer with Name there is only Name applied to title, but when i use slicer Area only area values are selected. There is no need to apply Area&Name in title. Just one of these.

Question is, how can i add to code above second slicer options?

[Daryl-Lynch-Bzy · Accepted solution]

Hi @hejszyszky , you could consider the following:

Slicer Selections = 
   VAR _Name = ISFILTERED ( 'Summarized Raport'[Name] )
   VAR _Area = ISFILTERED ( 'Summarized Raport'[Area] )
RETURN
  "PR % Impact by TOP10 Losses on " &
   SWITCH( TRUE() , 
      AND ( _Name , NOT ( _Area ) ) , "selected Names: " & CONCATENATEX ( VALUES ('Summarized Raport'[Name] ) , 'Summarized Raport'[Name] , "," ) , 
      AND ( _Area , NOT ( _Name ) ) , "selected Areas: " & CONCATENATEX ( VALUES ('Summarized Raport'[Area] ) , 'Summarized Raport'[Area] , "," ) ,
      AND ( _Area = TRUE , _Name = TRUE ) ) , "All selected Names and Areas" ,
      "Plant"
   )

[hejszyszky]

Hey! Works well, just had to edit. There is one paranthesis too much before 

"All selected Names and Areas" 

Thanks a lot! 

[hejszyszky]

Hmm, got unexpected expression NOT error

[Daryl-Lynch-Bzy]

@hejszyszky  - sorry, I have update to include AND function to allow the NOT work.

[amitchandak]

@hejszyszky , Try like

IF( ISFILTERED('Summarized Raport'[Name])
CONCATENATEX(values( 'Summarized Raport'[Name]),'Summarized Raport'[Name],",") )
&
IF( ISFILTERED('Summarized Raport'[Plant])
CONCATENATEX(values( 'Summarized Raport'[Plant]),'Summarized Raport'[Plant],",") )