Forum Discussion

Myurathan's avatar
Myurathan
Frequent Visitor
8 years ago

Need Help - Measures

I am currently learning DAX. I have created following measures.

Sales Table -->

 

SalesAmount := SUMX(Sales, Sales[Quantity]*Sales[Unit Price])

Product Table -->

 

ProductSalesAmount := SUMX(RELATEDTABLE(Sales),Sales[Quantity]*Sales[Unit Price])
ProductSalesAmount1 = SUMX(RELATEDTABLE(Sales),Sales[SalesAmount])

 

For my understanding, these two measures should give me same values, but they do not. 

 

Please explain me why these values differ?

 

Thanks in advance

 

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Myurathan,

    I am not able to reproduce this issue using my sample data.  Could you please share the data of your tables to me via Private Message?



    Regards,
    Lydia