Subtotals are the same value as totals

[pschn1993]

I am using the below formula and the subtotals are the same as the total for YTD Actl & YTD Bdgt. How can I adjust my formula to display the correct subtotals?

YTD Bdgt = var selectvalue = SELECTEDVALUE('Calendar'[monthnum])

var t =

CALCULATE(

SUM(financials_bdgt[Budget accounting amount]),

FILTER(

ALLEXCEPT(financials_bdgt,'Calendar'[fy],Mills[Location],Dpt[deptabrv],Accounts[Dim Ledger Accounts.Main account]),

financials_bdgt[Period - Fiscal.Fiscal Month] <= selectvalue

)

)

return

IF(

MINX(financials_bdgt,financials_bdgt[Period - Fiscal.Fiscal Month]) = selectvalue,

t,

BLANK()

)

[v-xiaotang]

Hi @pschn1993 

It seems something wrong with the red part below,

try to change it to

ALLEXCEPT (
                financials_bdgt,
                financials_bdgt[fy],
                financials_bdgt[Location],
                financials_bdgt[deptabrv],
                financials_bdgt[Dim Ledger Accounts.Main account]
            ),

or

filter(ALL(financials_bdgt),
financials_bdgt[fy]=min('Calendar'[fy]) &&
financials_bdgt[Location]=min(Mills[Location]) &&
financials_bdgt[deptabrv]=min( Dpt[deptabrv]) &&
financials_bdgt[[Dim Ledger Accounts.Main account]]=
min( Accounts[Dim Ledger Accounts.Main account]) &&
financials_bdgt[Period - Fiscal.Fiscal Month] <= selectvalue)

 However, without data we are just guessing. If the above doesn't help, could you share a sample file? Thanks

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[Tutu_in_YYC]

Hi, my guess is the total is correct for QA but not for the Admins. Is there a pbix I can have a look at?