Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Dynamic title

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]) & ...
Need Help
Show and Tell
Tutorial Requests
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    5 years ago

    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's avatar
amitchandak
Super User
5 years ago

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/