topic Re: Total for percentage calculation in DAX Commands and Tips

Total for percentage calculation

Solle — Tue, 07 Mar 2023 11:26:56 GMT

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 — Tue, 07 Mar 2023 12:04:09 GMT

try simply:

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

or?

Solle — Tue, 07 Mar 2023 12:06:53 GMT

hi FreemanZ,

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

Do you have any other suggestions?

FreemanZ — Tue, 07 Mar 2023 12:11:17 GMT

how about this:

MV Ultimo inkl. Accrued Interest Total =

Calculate(

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

ALL(FactAfkast),

ALL(DimDate),

VALUES(DimDate[Date])

)

Solle — Tue, 07 Mar 2023 12:14:08 GMT

Hi FreemanZ,

Appreciate your help this seems to have solved the issue.

Thank you and have a nice day 🙂