Forum Discussion

JMSNYC's avatar
JMSNYC
Helper III
7 years ago
Solved

Bubble Chart and DAX Calculation

Hi.   I cannot figure out the way to build a bubble chart based on this data set, where    1- x-axis should be the total actual office visits for ANY given customer (i.e. sum column 2) 2- y-axis...
Need Help
  • Sean's avatar
    Sean
    7 years ago

    JMSNYC

    Start by creating these 3 Measures and 1 Column

     

    Visits = SUM ( 'Table'[Monthly_office_visit] )

Planned = SUM ( 'Table'[Monthly_office_planned] )

    Size Column =
    DIVIDE (
     CALCULATE ( [Visits], ALLEXCEPT ( 'Table', 'Table'[Customer_ID] ) ),
     CALCULATE ( [Planned], ALLEXCEPT ( 'Table', 'Table'[Customer_ID] ) ),
     0
    )

    Size Measure =
    CALCULATE (
     DISTINCTCOUNT ( 'Table'[Customer_ID] ),
     ALLEXCEPT ( 'Table', 'Table'[Size Column] )
    )

    Then create your bubble chart like this...

     

     

     

    Hope this helps! :smileyhappy:

Sean's avatar
Sean
Community Champion
7 years ago

JMSNYC

Start by creating these 3 Measures and 1 Column

 

Visits = SUM ( 'Table'[Monthly_office_visit] )

Planned = SUM ( 'Table'[Monthly_office_planned] )

Size Column =
DIVIDE (
 CALCULATE ( [Visits], ALLEXCEPT ( 'Table', 'Table'[Customer_ID] ) ),
 CALCULATE ( [Planned], ALLEXCEPT ( 'Table', 'Table'[Customer_ID] ) ),
 0
)

Size Measure =
CALCULATE (
 DISTINCTCOUNT ( 'Table'[Customer_ID] ),
 ALLEXCEPT ( 'Table', 'Table'[Size Column] )
)

Then create your bubble chart like this...

 

 

 

Hope this helps! :smileyhappy:

JMSNYC's avatar
JMSNYC
Helper III
7 years ago

Awesome. Works perfectly.