Forum Discussion

teatree's avatar
teatree
Frequent Visitor
9 years ago
Solved

Duplicating Map Legend

Hi,   My map seems to be duplicating each point on the map when both of my legends are selected.   So, I'm placing a pointer on a map to say that one is a client and the other is not a client. Wh...
  • Sean's avatar
    Sean
    9 years ago

    You are welcome! :smileyhappy:

    One more thing you may consider is concatenating columns into a new column solely for Tooltip Use.

    So first create a Column by concatenating the information you want to show in the Tooltip and then use this new column in a Measure!

    Hope this helps! :smileyhappy:

     

teatree's avatar
teatree
Frequent Visitor
9 years ago

Hi Lydia,

 

Your map is exactly what I'm looking to do. I've downloaded the file and have had a look at it but when I try to apply to my data, I get an error:

 

MdxScript(Model) (1, 43) Calculation error in measure 'Table1[EstablishmentNameMeasure]: A table of multiple values was supplied where a single value was expected.

 

I completely understand what you are doing and it is what I need to apply to my data. 

 

Do you know what I'm doing wrong?

 

teatree's avatar
teatree
Frequent Visitor
9 years ago

I assume this is because from the data clip that you used, every value was unique. 

 

I have several county's/postcode's which are the same.. 

 

So an establishment can be in the same location as another but will have a different name. I'm mainly using this for schools so for example:

 

The postcode: M29 8BS has 4+ records assigned against it:

 

Establishment Name

Postcode

County

Client

Customer Code

Establishment Type

Establishment Phase

Cambian 110 Peelhouse

 M29 8BS

Manchester

Yes

CAM01

Other Independent

Secondary

Cambian Meadow Road

 M29 8BS

Manchester

No

 

Other Independent

Primary

Cambian Tyldesley School

 M29 8BS

Manchester

No

 

Other Independent

Secondary

Cambian Willoughby School

 M29 8BS

Manchester

Yes

CAM02

Other Independent

Primary

 

I'm assuming this is why I'm getting the error when placing the measure in tooltips? 

 

Francesca

  • Sean's avatar
    Sean
    Community Champion
    9 years ago

    teatree Did you try the Measure (underlined in red) in the first picture (top left corner) from my Last Resposne?

     

    Establishments = CONCATENATEX ( VALUES('TableName'[Establishment Name]), 'TableName'[Establishment Name],", ")

     

     

  • teatree's avatar
    teatree
    Frequent Visitor
    9 years ago

    Hi Sean,

     

     

    Sorry, I missed your post! This seems to actually be working v well for me. Let me keep playing with it and make sure that this is indeed what I need. Thank you so much :)

     

    Francesca

  • Sean's avatar
    Sean
    Community Champion
    9 years ago

    You are welcome! :smileyhappy:

    One more thing you may consider is concatenating columns into a new column solely for Tooltip Use.

    So first create a Column by concatenating the information you want to show in the Tooltip and then use this new column in a Measure!

    Hope this helps! :smileyhappy:

     

  • teatree's avatar
    teatree
    Frequent Visitor
    9 years ago

    Sean! Thank you ever so much, I would be so lost without you :catlol:

     

    This has worked for me!!

     

    Thank you again!

    Francesca