The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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!
Solved! Go to Solution.
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!
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]
)