Forum Discussion
Solved
Summing Totals in Matrix Hierarchy
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 locati...
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]
)
That did the trick. Thank you!