Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello guys,
I need your help with calculating the an average from a measure.
In this measure, there is a formula which gives a certain result, this table is called Amount.
I tried the formula SUM(amount)/ distinctcount(amount) but this isn't working.
Does anyone have an idea how to resolve this?
See the attached table:
Thanks!!
Hi @Stroopwafels,
In your screenshot, the column "What I want" and "Amount" are same, what's the calculation rules for data, please clear up your requirement.
Best Regards,
Angelia
I'm not exactly sure what you are asking, but check this post and see if it helps:
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |