DAX Help!

[JLYT]

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 ID	Purchase 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

[JLYT]

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

[FreemanZ]

hi @JLYT 

try to plot a visual with User ID column and a measure like:

Measure = SUM(Sales[Purchase Amount])