Forum Discussion
Matrix Row and Columns Subtotal are not calculating correctly
- 2 years ago
Hi Vayne-Daryl, Hope you are doing good!
Please try the below measuresTest Measure =
VAR CurrentFiscalYear = SELECTEDVALUE('Calendar'[Fiscal Year])
VAR StartFiscalMonth =
CALCULATE(
MIN('ApplicationCost'[StartDateFiscalMonth]),
FILTER(
'ApplicationCost',
'ApplicationCost'[ApplicationName] = SELECTEDVALUE('ApplicationCost'[ApplicationName]) &&
'ApplicationCost'[Control Number] = SELECTEDVALUE('ApplicationCost'[Control Number]) &&
'ApplicationCost'[FiscalYear] = CurrentFiscalYear
)
)
VAR Result =
SUMX(
'ApplicationCost',
IF(
'ApplicationCost'[FiscalYear] = CurrentFiscalYear &&
'ApplicationCost'[StartDateFiscalMonth] <= MAX('Calendar'[Fiscal Month]),
'ApplicationCost'[Value],
0
)
)
RETURN
ResultFinal Measure =
SUMX(
SUMMARIZE(
'ApplicationCost',
'ApplicationCost'[ApplicationName],
'ApplicationCost'[Control Number],
"MonthValue", [Test Measure]
),
[MonthValue]
)Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!
Hi, Vayne-Daryl
Didn't simulate your problem, you can provide pbix files without sensitive information for testing, feel free to help you about this problem.
Best Regards,
Yang
Community Support Team
Hi Yang,
Thank you so much for your reply but unfortunately our system is blocking any uploads to external resources. But it seems to me that the solution from anmolmalviya05 solved the issue 🙂
Thanks Again.