Forum Discussion

malkha's avatar
malkha
Regular Visitor
6 years ago

Measure Total not correct

 

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.

 

 

incorrect total

3 Replies

  • az38's avatar
    az38
    Community Champion
    6 years ago

    Hi malkha 

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

     

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

    • malkha's avatar
      malkha
      Regular Visitor
      6 years ago

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

       

       

      • az38's avatar
        az38
        Community Champion
        6 years ago

        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