Forum Discussion

thelo09's avatar
thelo09
New Member
3 years ago

Dynamic measure map visual

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?

1 Reply