topic Measure Total not correct in DAX Commands and Tips

Measure Total not correct

malkha — Mon, 13 Jan 2020 21:36:52 GMT

why isnt this measure below totalling correctly?my cummlative formula works fine until it hits december. where December is the forecast data. As you can see on the table on the right. i have the correct value showing fore forecast but total is incorrect.

Re: Measure Total not correct

az38 — Mon, 13 Jan 2020 21:36:25 GMT

Hi malkha

try to use IF(CALCULATE(SUM(....)), statement

do not hesitate to give a kudo to useful posts and mark solutions as solution

Re: Measure Total not correct

malkha — Mon, 13 Jan 2020 21:54:28 GMT

i am not sure if i am typing your equasion wrong, but i am still yeilding the same total. az38

Re: Measure Total not correct

az38 — Tue, 14 Jan 2020 06:17:16 GMT

malkha

what result do you expect in total row? it should be sum of all rows or logic IF should be implemented on whole data massive?

also, you could try smth like that

Measure = sumx('Fcst Vs Actuals'; if(calculate(sum('Fcst Vs Actuals'[Capital_Actuals]))=0; calculate(sum('Fcst Vs Actuals'[Capital_Forecast])); calculate(sum('Fcst Vs Actuals'[Capital_Actuals]))))

do not hesitate to give a kudo to useful posts and mark solutions as solution