Forum Discussion

AaronGlenn10's avatar
AaronGlenn10
Helper III
4 years ago
Solved

Dynamic Title with Multi-Level Hierarchy

All Stars:   Trying to create a dynanmic title based on a user's selection of a city or a business location within a city.  When I used a CONCATENATE measure the SELECTED BUSINESS LOCATION works, b...
Need Help
  • v-kkf-msft's avatar
    v-kkf-msft
    4 years ago

    Hi AaronGlenn10 ,

     

    Please try the following formula:

     

    Measure = 
VAR city = CONCATENATEX ( VALUES ( 'Table'[City] ), [City], " , " )
VAR Location = CONCATENATEX ( VALUES ( 'Table'[Location Snapshot] ), 'Table'[Location Snapshot], "," )
RETURN IF ( ISFILTERED ( 'Table'[Location Snapshot] ), Location, city )

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
    Best Regards,
    Winniz
    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
4 years ago

AaronGlenn10 ,

concatenatex( sumamrize(City, City[City], city[BUSINESS LOCATION]) , [City] & " - " [BUSINESS LOCATION] , " , ")

  • AaronGlenn10's avatar
    AaronGlenn10
    Helper III
    4 years ago

    When I select just the CITY it still displays all the locations within that CITY in the title... trying to display just the CITY's NAME when the CITY is selected.

    • v-kkf-msft's avatar
      v-kkf-msft
      Community Support
      4 years ago

      Hi AaronGlenn10 ,

       

      Please try the following formula:

       

      Measure = 
VAR city = CONCATENATEX ( VALUES ( 'Table'[City] ), [City], " , " )
VAR Location = CONCATENATEX ( VALUES ( 'Table'[Location Snapshot] ), 'Table'[Location Snapshot], "," )
RETURN IF ( ISFILTERED ( 'Table'[Location Snapshot] ), Location, city )

       

      If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
      Best Regards,
      Winniz
      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.