Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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
Solved! Go to Solution.
SUMMARIZE by transaction ID and then add MIN, MAX or AVERAGE aggregation of Spent (but not SUM)
Then COUNTROWS , SUMX and AVERAGEX the result.
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
many thanks!!!😃
User | Count |
---|---|
12 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
19 | |
14 | |
8 | |
7 |