Forum Discussion

JLYT's avatar
JLYT
Frequent Visitor
3 years ago

DAX Help!

Hi all,

 

I am a newbie here and still trying to learn all DAX expressions.

I have a scenraio where my table contains all users' purchase records, for example:

User IDPurchase Amount
001$50
001$150
002$500
002$30

I would like to calculate the total purchase amount per user for visuals. 

Shall I adding a new measure or a new table? If a measure is okay, what would the DAX code be?

I tried

User Total Amount Purchased = CALCULATE(SUMX(sales,sales[purchaseamount]),sales[userid])

But it doesn't work?

 

Any advice would be appreciated! 

 

Thanks
Jennifer

Need Help

2 Replies

  • FreemanZ's avatar
    FreemanZ
    Super User
    3 years ago

    hi JLYT 

    try to plot a visual with User ID column and a measure like:
    Measure = SUM(Sales[Purchase Amount])
  • JLYT's avatar
    JLYT
    Frequent Visitor
    3 years ago

    Hi,

    Silly me!!!Thank you so much!

    I have 2 calculated measures and a calculated column based on the 2 calculated measure.
    Then I want to group the values in the calculated column but it keeps coming up with the 'circular dependency' error. I have looked at a few guide but can't figure it out.
    Is it because I can't use calculated column with multiple calculated measures?

    Thanks

    Jennifer