Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Dynamic Title - Multiple Selections

Here's my current formula:    Selected Zone = var selectedcolor = SELECTEDVALUE('All Data'[Zone]) return "Zone: "& IF(ISBLANK(selectedcolor), "All", selectedcolor)    However, when I select more ...
Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    8 years ago

    Hi Anonymous

     

    You may try to use below measure. Here is the reference for you.

    Selected Zone =
VAR selectedcolor =
    VALUES ( 'All Data'[Zone] )
RETURN
    "Zone: "
        & IF (
            COUNTROWS ( selectedcolor ) = COUNTROWS ( ALL ( 'All Data'[Zone] ) ),
            "All",
            CONCATENATEX ( VALUES ( 'All Data'[Zone] ), 'All Data'[Zone], "," )
        )

    Regards,

    Cherie

KarenF's avatar
KarenF
New Member
7 years ago

Hi Anonymous

 

Can you please share your fix with me. I'm struggling to get mine to work when all are selected. Like you, when I slected all, the title listed everything instead of saying 'All Selected'. However it works great when selecting individual ones. So if 3 name selected it shows those 3 names

 

Many thanks

Karen

KarenF's avatar
KarenF
New Member
7 years ago

Think ive resolved it

 

Test Title For Dynamic Contractor Title v2 =

VAR SelectedContractors =

   VALUES (Contractor[Contractor_Name])

RETURN

    "Contractor/s: "

 

&  IF(NOT(ISFILTERED(Contractor[Contractor_Name])),"All Contractors" , IF( ISFILTERED(Contractor[Contractor_Name]), CONCATENATEX ( VALUES (Contractor[Contractor_Name]), Contractor[Contractor_Name], "," )))