Dynamic measure map visual

thelo09 — Tue, 05 Sep 2023 11:56:58 GMT

Hi,

I have to create a attractiveness map visual to choose a city and this map has to work with 3 dynamic parameters that will work like a weight (from 1 to 10).
The person can choose the weight from 1 to 10 depending on their preference, for example, 'total invoicing' will have weight 3 and 'total costumers' will have weight 8..

So a created a measure called 'Attractiveness' from the weight parameters and other measures that show me the rank percentile:

Attractiveness = ROUND(((('Weight Total Invoicing'[Value Weight Total Invoicing]*[Rank_perc_total_invoicing]+
'Weight Total costumers'[Value Weight Total costumers]*[Rank_perc_total_costumers]+
'Weight Average ticket'[Value Weight Average ticket]*[Rank_perc_aver_ticket]+
)
/
('Weight Total Invoicing'[Value Weight Total Invoicing]+
'Weight Total costumers'[Value Weight Total costumers]+
'Weight Average ticket'[Value Weight Average ticket]
))/10)*10,1)

Then, I created a map visual with the location, 'Cities name' in the Legend field and I inserted the 'Attractiveness' measure in the bubble size.

My problem is, the 'Attractiveness' measure is not working, its showing me value '10' in the tree cities but when I tested in another visual (a bar chart) it worked.

Can someone help me please?

Re: Dynamic measure map visual

Anonymous — Thu, 07 Sep 2023 02:19:08 GMT

Hi thelo09 ,

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly

Regards,

Xiaoxin Sheng

topic Dynamic measure map visual in DAX Commands and Tips

Dynamic measure map visual

Re: Dynamic measure map visual