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 sales it's ten. As you can see summing the 5 totals.

 

But. When I do the measure I don't have the same result. I notice that it's a common problem but i didn't figure how to solve it (Filter? Related? which function?)

 

So. This is my dax formula:

 

 

Thanks!

  • Hi Anonymous

     

    This is where DAX iterators come in :)

     

    Please try

     

     

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

     

1 Reply

  • Phil_Seamark's avatar
    Phil_Seamark
    Microsoft Employee

    Hi Anonymous

     

    This is where DAX iterators come in :)

     

    Please try

     

     

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