[Map][Tooltip] Issue displaying biggest customer DAX/formula - map point limits

[Raffael]

Hello PowerBI community,

I created the following Measure

Biggest Customer Name = Lookupvalue('Atlas kurz'[Customer - Global HQ]; 'Atlas kurz'[OR Total]; 'Calculated Measures'[OR Total max per Customer])

to return the name of the biggest customer by orders received in the selected region.

This works totally fine for cards, but wheb i want to add it to tooltips, so it shows the biggest customer of a city on the city's tooltip, the map object crashes with the following error message:

The previously used measure looks like this

OR Total max per Customer = 
MAXX(
	KEEPFILTERS(VALUES('Atlas kurz'[Customer]));
	CALCULATE(SUM('Atlas kurz'[OR Total]))
)

A seperate problem to this occurs when using cards: 

The City goes blank when the Customer with the determined OR Total is not mapped (at least it appears so, i tested it once with whole country (name goes (blank) and then with region of the customer (name was shown)

Is there an elegant to work around this? 

Any help is highly appreciated. 🙂 

[v-yulgu-msft]

Hi @Raffael,

I could not reproduce the same problem on my side after some general test.

Which Map visual did you use? Please provide sample data so that I can test your scenario on my side.

How to Get Your Question Answered Quickly

Regards,

Yuliana Gu

[Raffael]

Hello Yuliana Gu,

I used the standard MS Bing Map Visual.

By coincidence i think i was able to narrow down the issue.

it seems the function crashes when there's mulitples of the same OR Total that ought to be displayed. My card elements crash in these scenarios as well.

Sample data looks like this:

Customer	City	OR Total
Customer 1	Washington	$ 10.000,00
Customer 2	Nashville	$ 20.000,00
Customer 3	Boston	$ 10.000,00

Alas i don't know how to tackle this...

Greetings,