Controlling the bubble size in a scatter chart

Hi jamesbr,

By default, if we drag a column into "Size" section in a scatter chart, it will be aggregated, like Sum, Average, Count, etc. To avoid this beavior, we can add a measure insetad of adding column directly. Below is my test, please review it.

Add a calculated column [Bubble Size] in sales table.

Bubble Size =
LOOKUPVALUE (
    'Bubble Size'[Close Rate],
    'Bubble Size'[Name], 'Sales of team'[Name]
)

Create a measure.

Bubble Size measure =
CALCULATE (
    LASTNONBLANK ( 'Sales of team'[Bubble Size], 1 ),
    ALLEXCEPT ( 'Sales of team', 'Sales of team'[Name] )
)

Add this measure into "Size" section.

Best regards,
Yuliana Gu