topic Re: Unique Average Calculation in DAX Commands and Tips

Unique Average Calculation

Anonymous — Thu, 07 Mar 2024 16:14:50 GMT

Hi,

I have a table (attached) where I have some transactions duplicated....My chalenge is by power BI try to find the average ticket, but by function "AVG" or by "sum spent / sum transactions) is delivering wrong values....

Can you help me, please?

Many thanks in advance,

Rui

Re: Unique Average Calculation

lbendlin — Thu, 07 Mar 2024 20:42:01 GMT

SUMMARIZE by transaction ID and then add MIN, MAX or AVERAGE aggregation of Spent (but not SUM)

Then COUNTROWS , SUMX and AVERAGEX the result.

Re: Unique Average Calculation

Anonymous — Thu, 07 Mar 2024 23:24:55 GMT

Hi,

Thanks for your answer. Following this example, can you please help me to write the code (I'm a beginner in PBI 🙂 )

Thanks

Rui

Re: Unique Average Calculation

lbendlin — Fri, 08 Mar 2024 00:19:24 GMT

Re: Unique Average Calculation

Anonymous — Fri, 15 Mar 2024 17:00:58 GMT

many thanks!!!😃