Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |