Summing Totals in Matrix Hierarchy

[BrianNeedsHelp]

I have this simple measure to compute what we need each day for the days remaining in month to reach a goal of 50.  

Need Per Day=(50-[Gross Adds])/([DaysRemaining])

This works fine at the location level, which is the lowest level in the Matrix.  So the next hieararchy level in the matrix is the Sales Manager.  The Sales Manager totals are showing negative.  What I'm expecting is to have it sum all of the [Need Per Day] for each manager.  What am I missing here?  This makes no sense.  Thank you!   

[BrianNeedsHelp]

That did the trick.  Thank you!  

[MasonMA · Accepted solution]

@BrianNeedsHelp 

Hi, I think what happened is likely that Power BI creates a new filter context for all locations under that manager. It calculates:

`[Gross Adds]` = SUM of all locations' gross adds `[DaysRemaining]` = SUM of all locations' days remaining. And then does: (50 - total gross adds) / total days remaining.

You may consider using VALUES with Locations to have it return a single column, which also inherits Filter contexts from your matirx visual. Example DAX like below:

Measure =
SUMX(
VALUES('Table'[Location]),
(50 - [Gross Adds]) / [DaysRemaining]
)