The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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. 🙂
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
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,