Total for percentage calculation

[Solle]

Hi, 

I am struggeling a bit with calculating the totals across all my "aktivklasse" as I have a date filter, which should be taken into account. 

I have tried to using this formula, but with no effect.

MV Ultimo inkl. Accrued Interest Total =
Calculate(

    SUM(FactAfkast[MV Ultimo inkl. Rente]),

    ALLSELECTED(DimDate[Date])

)

What I want to achive is

Aktivklasse	MV Ultimo inkl. accrued interest	MV Ultimo inkl. Accrued Interest Total
Asset Class 1	15.202.495.840,05	35.762.346.770,72
Asset Class 2	4.395.622.891,90	35.762.346.770,72
Asset Class 3	7.591.033.319,98	35.762.346.770,72
Asset Class 4	1.257.104.088,76	35.762.346.770,72
Asset Class 5	4.597.048.681,13	35.762.346.770,72
Asset Class 6	61.798.625,14	35.762.346.770,72
Asset Class 7	2.657.243.323,76	35.762.346.770,72

Hope someone can help me out.

Best Regards,

[FreemanZ]

hi @Solle 

try simply:

MV Ultimo inkl. Accrued Interest Total =
SUM(FactAfkast[MV Ultimo inkl. Rente])

or?

[Solle]

hi @FreemanZ, 

Thank you for your response - Unfortunately this does not solve the problem. 

Do you have any other suggestions?

[FreemanZ · Accepted solution]

hi @Solle 

how about this:

MV Ultimo inkl. Accrued Interest Total =

Calculate(

    SUM(FactAfkast[MV Ultimo inkl. Rente]),

    ALL(FactAfkast),

    ALL(DimDate),

    VALUES(DimDate[Date])

)

[Solle]

Hi @FreemanZ,

Appreciate your help this seems to have solved the issue. 

Thank you and have a nice day 🙂