Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Dynamic Title with Values from Multiple Slicers

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 ...
Need Help
  • Ritaf1983's avatar
    Ritaf1983
    3 years ago

    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

Ritaf1983's avatar
Ritaf1983
Super User
3 years ago

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's avatar
Anonymous
Not applicable
3 years ago

This makes sense, and it works, thanks!

  • Ritaf1983's avatar
    Ritaf1983
    Super User
    3 years ago

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