Forum Discussion

ShaunDalton's avatar
ShaunDalton
New Member
4 years ago

Sum from a Scatter Plot

I have a scatter plot where I have placed an average line from the analytics pane on the x and y axis. I would like to create a measure that would dynamically sum the scatter points in the left bottom quandrant.

 

Is this possible? 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi ShaunDalton ,

     

    You could create a measure like

    Left bottom quandrant = CALCULATE(SUM('Table'[Value]),FILTER(ALLSELECTED('Table'),[Axis]<0&&[Value]<0))

    If you are still confused about it, please provide me with more details about your problem.

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • ShaunDalton's avatar
    ShaunDalton
    New Member
    4 years ago

    Is this some way to make your left bottom quadrant sum when it is less than an average ? I have attached my first go at it above