Dynamic title

[Anonymous]

Hi,

I have this as a dynamic title

Selected Year1 = "Sales and Pipeline Report for " & SELECTEDVALUE('Business area'[Business Area ]) & " " & SELECTEDVALUE('New Date Table'[year].[Year]) & " "

Is there a way to add UK as defualt when there is no selection or all selected

[v-yalanwu-msft · Accepted solution]

Hi, @Anonymous ;

You could modify the measure like below:

Selected Year1 =
"Sales and Pipeline Report for "
    & IF (
        CALCULATE (DISTINCTCOUNT ( 'Business area'[Item Code] ),ALL ( 'Business area' ))
            = CALCULATE (DISTINCTCOUNT ( 'Business area'[Item Code] ), ALLSELECTED ( 'Business area' )),
        "UK",SELECTEDVALUE ( 'Business area'[Item Code] )) & " "
    & SELECTEDVALUE ( 'New Date Table'[year].[Year] ) & " "

The final output is shown below:

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , for which value, say 'Business area'[Business Area ] or both then use &&

when not filtered 

Selected Year1 = if( isfiltered('Business area'[Business Area ]) , "Sales and Pipeline Report for " & SELECTEDVALUE('Business area'[Business Area ]) & " " & SELECTEDVALUE('New Date Table'[year].[Year]) & " " ,

"UK")

https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/