DAX AverageX

[dicken]

Hi,
I'm having a problem understanding what I'm doing wrong;

I have a measure for Revenue;

<
SUMX(fTransactions,

fTransactions[UnitsSold]*(1- fTransactions[Discount])*RELATED(dProduct[RetailPrice]) ) >

This works, and then I wanted the average so; (dDate = date table)

< AVERAGEX ( dDate, [Revenue] ) >

This also works, but for practice I'd like to actually type it all out rather than using the measure within AVERAGEX,
So thought,

< AVERAGEX( dDate, CALCULATE (
SUMX(fTransactions, fTransactions[UnitsSold]*(1- fTransactions[Discount])*RELATED(dProduct[RetailPrice]) ) >

Would work, but I get continual errors highlighted, I've tried not using Calculate but am a bit stuck.

Richard.

 

[Matt Allington]

Your missing 2 closing brackets at the end. Use daxformatter.com when you are stuck like this

 

[dicken]

Thanks Matt, ( I do have your book), unfortunately that only half worked, yes I no longer get an error but the when dropped
into a 'card' in visualizations, they don't show the same figure. I did cut and paste the formula,
Any suggestions as to what I'm doing wrong?

Richard.

 

[dicken]

Your missing 2 closing brackets at the end. Use daxformatter.com when you are stuck like this

Ignore other email, in my slap dash manner I forgot to wrap in 'calculate' .
BTW I like your book, but there's a 'but' coming, and that's I'd have liked more on using Calculate with filter, and context
transition but I'd recommend it.

Richard.

 

[Matt Allington]

Fair point about CALCULATE. The book is a beginner's book, but your point is noted.