topic Re: Kolom total in a report in DAX Commands and Tips

Kolom total in a report

Eric12 — Fri, 28 Apr 2023 10:37:21 GMT

Hello,

I have a report where i calculate the expected cost, based on actual cost and percentage of completion. On row level i get the correct value, but the total is not correct. How come? hereunder my formula (last kolom rows are correct)

Verwachte Nacalculatie =

if(sum(Projectfases[PrjFas_Voortgangperc])>0,

sum(NacalculatieoverzichtChecklist[NC_Verkoopbedrag])/sum(Projectfases[PrjFas_Voortgangperc]),

if(sum(NacalculatieoverzichtChecklist[NC_Verkoopbedrag])<sum('Voorcalculatieregel overzicht Checklist'[VCReg_Regelbedrag]),

sum('Voorcalculatieregel overzicht Checklist'[VCReg_Regelbedrag]),

sum(NacalculatieoverzichtChecklist[NC_Verkoopbedrag])))

Re: Kolom total in a report

Mahesh0016 — Fri, 28 Apr 2023 13:03:12 GMT

Eric12
Verwachte Nacalculatie =
IF (
SUM ( Projectfases[PrjFas_Voortgangperc] ) > 0,
DIVIDE (
SUM ( NacalculatieoverzichtChecklist[NC_Verkoopbedrag] ),
SUM ( Projectfases[PrjFas_Voortgangperc] ),
0
),
IF (
SUM ( NacalculatieoverzichtChecklist[NC_Verkoopbedrag] )
< SUM ( 'Voorcalculatieregel overzicht Checklist'[VCReg_Regelbedrag] ),
SUM ( 'Voorcalculatieregel overzicht Checklist'[VCReg_Regelbedrag] ),
SUM ( NacalculatieoverzichtChecklist[NC_Verkoopbedrag] )
)
)

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

Thank You!!

Re: Kolom total in a report

Eric12 — Fri, 28 Apr 2023 13:27:25 GMT

Mahesh0016

Unfortunately this doesn't do the tric. I get a percentage per row as a result