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.

v-yalanwu-msft's avatar
v-yalanwu-msft
Icon for Community Support rankCommunity Support
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.