Forum Discussion
Summing Totals in Matrix Hierarchy
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]
)
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]
)