topic DAX Measure for Revenue average by Order in DAX Commands and Tips

DAX Measure for Revenue average by Order

zirael — Mon, 17 Oct 2022 10:54:35 GMT

Hi,

I have a fact table like the one below. I need to create a measure calculating the average value of order (OrderKey)

Would you help?

Stachu — Mon, 17 Oct 2022 16:59:43 GMT

try this:

Avg Order Revenue = AVERAGEX ( DISTINCT ( 'Table'[OrderKey] ), CALCULATE ( SUM ( 'Table'[SalesRevenue] ) ) )

Anonymous — Tue, 18 Oct 2022 05:20:20 GMT

Please have a try.

Create a measure.

ave_measure = AVERAGEX ( FILTER ( ALL ( 'Table' ), 'Table'[OrderNumber] = SELECTEDVALUE ( 'Table'[OrderNumber] ) ), 'Table'[SalesRevenue] )

Or a column.

ave = AVERAGEX ( FILTER ( 'Table', 'Table'[OrderNumber] = EARLIER ( 'Table'[OrderNumber] ) ), 'Table'[SalesRevenue] )

If I have misunderstood your meaning, please provide more details with your desired output.

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.