Cumulative Total for more than 1 dimension

[dhayanithij79]

We have "Datacenter" in Rows and "Month-Period" in Column respectivly in crosstab.

Want to display cummulative forecast of storage, compute, backup etc as measures.

Here is the formula I have for displaying the cummulative total.

Cumulative Forecast =
CALCULATE (
Sum(Forecast[Total Storage (TB)]),
FILTER (
ALLSELECTED(Forecast),
Forecast[Required Month] <= Max( Forecast[Required Month] )
)
)

It works fine but it calculates cummulative total for all datacenter. Want to break it by datacenter. 

Foreach datacenter I want to see cummulative total by period.

Any help will be much appreciated.

[v-frfei-msft]

Hi @dhayanithij79,

Has your issue been solved by the formula as @Zubair_Muhammad offered? If any question, feel free to let me know please.

Regards,

Frank

[Zubair_Muhammad]

@dhayanithij79

Try adding another filter argument as follows

Cumulative Forecast =
CALCULATE (
    SUM ( Forecast[Total Storage (TB)] ),
    FILTER (
        ALLSELECTED ( Forecast ),
        Forecast[Required Month]
            <= MAX (
                Forecast[Required Month]
                    && Forecast[Datacentre] = SELECTEDVALUE ( Forecast[Datacentre] )
            )
    )
)

[easyleesie]

Thanks for your response, @Zubair_Muhammad I need exactly this and have tried (see below), but I get 

"The MAX function only accepts a column reference as an argument"

Am I missing something? 

CumDAC =

CALCULATE(

sum(FactTable[DAC]),

FILTER(

ALLSELECTED(FactTable),

FactTable[Date]

<=max(

FactTable[Date]

&& FactTable[Policy]=SELECTEDVALUE(FactTable[Policy])

)

)

)

[Zubair_Muhammad]

Hi

I notice that you are not closing bracket after max (facttable[date] )