Dynamic Title Help

[AaronGlenn10]

All Stars:

I have a drop down menu with Cities and Business Names within those cities - trying to create a measure that creates a title based on the selection of either City or Business Name.  I can create one for city or business name, but not both.

Selected City or Location = selectedvalue(TABC[City Key])

Combine values in a new column then point to that column??

Also, it's ok if the City Name displays along side the Business Name in the title if that's the solution.

I feel like this is an easy fix, just not seeing the solution.

[v-henryk-mstf · Accepted solution]

Hi @AaronGlenn10 ,

You can add a filter like the following. Refer to a formula like the following:

M_ =
CONCATENATEX (
    FILTER ( ALL ( 'Table' ), 'Table'[Company] IN { "A", "B", "F" } ),
    'Table'[Company],
    ","
)

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your feedback.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@AaronGlenn10 ,

Selected City or Location = selectedvalue(TABC[City Key]) & concatenateX(TABC, TABC[Business Name], " , ")

or

Selected City or Location = concatenateX(TABC, TABC[City Key] & TABC[Business Name], " , ")

[AaronGlenn10]

Thank you.  It works greeat when just selecting a Business Name, however, when you select a City, it lists every business name within that city -- see screenshot below.  Is there a measure that would exclude or filter out the business names under the City?