Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Incorrect calculation with blank sum

Hi, I have a measure to calculate the Volume Impact. But it is incorrect when the [Volume Sum] is blank.  If the [Volume Sum] is blank, it should be set as 0. For example, Product A in 2020-10, the...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    Hi,

    Try these measures

    Measure = ([Volume Sum]-[Volume last year])*[AUSP Last Year]
    Measure 2 = if(HASONEFILTER('Calendar'[YearMonth]),[Measure],sumx(summarize('Calendar','Calendar'[YearMonth],"ABCD",[Measure]),[ABCD]))

    The Grand total does not match but am unable to find out my mistake.

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
4 years ago

Hi,

Try these measures

Measure = ([Volume Sum]-[Volume last year])*[AUSP Last Year]
Measure 2 = if(HASONEFILTER('Calendar'[YearMonth]),[Measure],sumx(summarize('Calendar','Calendar'[YearMonth],"ABCD",[Measure]),[ABCD]))

The Grand total does not match but am unable to find out my mistake.

Hope this helps.