Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Difference Between DAX and calculated column

Hello!    I’m' trying to figurate the difference between calculate the 'Total sales' in a column and in a measure because the output it's difference.   This is mi data:   So, the total ...
Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    8 years ago

    Hi Anonymous

     

    This is where DAX iterators come in :)

     

    Please try

     

     

    Measure = SUMX('Data','Data'[Price] * 'Data'[Qty])

     

Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Anonymous

 

This is where DAX iterators come in :)

 

Please try

 

 

Measure = SUMX('Data','Data'[Price] * 'Data'[Qty])