Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
kylerligon
New Member

Finding the overall sum from a filter set while respecting the Play Axis slice on a scatter chart

Main objective: Display sum of all plan's enrollment from slicer group on a scatter plot with play axis.  

Dataset looks like: Tbl Name: Plan_Year

Plan number | Plan Type | Parent Name | Enrollment | Year 

XXXXXXXX    | Annual      | ABC Inc.        | 1234           | 2017

 

I created a measure to sum up the Enrollment over slicers for Plan Type and Parent Name. 

Enrollment Sum of Selected = sumX(ALLSELECTED(Plan_Year), Plan_Year[Enrollment]) .  However, this measure doesn't seem to respect the slicing done by Year when I make a Scatter Chart with Year on the Play Axis.  Any idea how to get to a solution?  

 

2 REPLIES 2
Anonymous
Not applicable

Just use 

Enrollment Sum of Selected  = SUM(Plan_Year[Enrollment ]).

 

then power BI will take care rest. 

If you are Visual as Date, it will calculate accordingly based on date.

if you are Visual has Plan only, then calculate Sum for a given plan.

 

I should say that Details of the Scatter Chart contains the Plan Number.  That measure would only show each Plan Number's Enrollment over the years when I need each plan to show the sum of all Plan Number's Enrollment in that given Year and filter set.  

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors