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.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi MFelix , thank you for the modified measures. After applying the suggested measures, the value doesn't seem correct too. [Volume Impact] for product A supposed to have same value as [Revenue YoY].

 

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

Did you do + 0 or =0