Dynamic Title with Values from Multiple Slicers

[Anonymous]

Hi all,

I have a table with categories scattered across four columns (branch, digital, email, cbcc) and they all have the same yes/no values e.g., "Branch" or "Not Branch". I'm allowing users to select only the "yes" values as I'm filtering out the "no" values for all columns in each of the four slicers below:

I want to have a dynamic title that can only show selected values, for instance, looking at the above image: "12 Months Rolling Forecast - Digital, CBCC Outbound",  and this title should change when 1, 2, 3, or all 4 values are selected. If no values values are selected I want to show "12 Months Rolling Forecast - Overall". 

This is what I have so far but I'm getting nowhere:

Forecast Title = 

var _branch = ISFILTERED ( Leads_summary_db2[Centrel_opp_fc] )
var _digital = ISFILTERED ( Leads_summary_db2[Digital_fc] )
var _email = ISFILTERED( Leads_summary_db2[Email_fc] )
var _cbcc = ISFILTERED( Leads_summary_db2[CCC_outbound_fc] )

return

  "12 Months Rolling Forecast - " &
   SWITCH( TRUE() , 
      AND ( _branch , NOT ( _digital ) ) , "Branch",
      AND ( _digital , NOT ( _branch ) ) , "Digital",
      AND ( _email , NOT ( _branch ) ) , "Email",
      AND ( _cbcc , NOT ( _branch ) ) , "CBCC Outbound",
      AND ( _digital = TRUE , _branch = TRUE ) , "Branch, Digital" ,
      AND ( _email = TRUE , _branch = TRUE ) , "Branch, Email" ,
      AND ( _cbcc = TRUE , _branch = TRUE ) , "Branch, CBCC Outbound" ,
      "Overall"
   )

Thanks so much in advance.

[Ritaf1983 · Accepted solution]

Hi @Anonymous 
To make it work you need your Dax to have all possible scenarios of selections .
I created a measure of 4 of them just to show you how it works, you need to continue from here :

test =

 var branch = ISFILTERED('Table'[Branch])

 var digital = ISFILTERED('Table'[Digital])

 var email = ISFILTERED('Table'[email])

 var cbcc = ISFILTERED('Table'[cbcc])

Return

if (branch=false && digital=true && email= true && cbcc = true, "12 Months Rolling Forecast - digital,email,cbcc",

if (branch=false && digital=false && email= true && cbcc = true, "12 Months Rolling Forecast - email,cbcc",

if (branch=false && digital=false && email= true && cbcc = true, "12 Months Rolling Forecast - email,cbcc",

if(branch=false && digital=false && email= false && cbcc = true, "12 Months Rolling Forecast -cbcc",

if(branch=true && digital=true && email= true && cbcc = true, "12 Months Rolling Forecast - digital,email,cbcc","you need to continue with  your conditions"

)))))

Link to a sample file 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[Anonymous]

This makes sense, and it works, thanks!

[Ritaf1983]

Glad to help , sorry that there is no quick and easy solution☺️