Dynamic Title with Multi-Level Hierarchy

[AaronGlenn10]

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, but when I select the CITY then the title displays the CITY name, and ALL the BUSINESS LOCATIONS within that CITY.  Any guidance would be much appreciated!  Thank you.

[amitchandak]

@AaronGlenn10 ,

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

[AaronGlenn10]

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 · Accepted solution]

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.