Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Maintaining bubble scaling during filtering

I've created a map using the Azure map visualization whre each location is represented by a bubble, and the scale of the bubble is based on the count of a metric at that location. I've added a filter...
Need Help
v-jingzhang's avatar
v-jingzhang
Icon for Community Support rankCommunity Support
4 years ago

Hi Anonymous 

 

Is your data similar to my sample file that all data comes from the same table? What's your code for total section (denominator) in DIVIDE currently? Can you show the result of the total?

Anonymous's avatar
Anonymous
Not applicable
4 years ago

hi v-jingzhang yes my data is in same format, all comes from single table. My measure code is below, I substituted my column names to match names from your date file. The code/math makes sense, just doesn't seem to work as intended when applied to sizing for bubbles on the map visualizations.

 

hours percentage =
SUMX('Table', 'Table'[Hours])/CALCULATE( SUM( 'Table'[Hours]), ALL('Table'[Year],'Table'[Location]))
  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    sorry correction, the location field is not used on the map, the bubbles are based on latitiude and longitude assigned to location, lat and long are each from a seperate table. So this is my code now: 

     

    hours percentage =
    SUMX('table 1','table1'[hours])/CALCULATE( SUMX( 'table 1','table1'[hours]), ALL('table 1'[year]),ALL('table 2'[latitude]),ALL('table 3'[longitude]))