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.
Hi, I'm having a dataset like this:
I want to calculate the average of each day's count. Since the count for the same is the same, I want each day's count be only calculated once.
Here is what I want:
Average = (100+200+300+400) / 4
Divided by 4 because there are 4 days in total.
Is it possible to achieve this by writing measures?
Any help is appreciated.
Solved! Go to Solution.
Please try this expression for a measure get your desired result (replacing Table with your actual table name)
New Measure = AVERAGEX(VALUES(Table[Date]), CALCULATE(AVERAGE(Table[Count])))
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
@Anonymous ,
Try like
divide(sumx(summarize(Table, Table[date],table[count]),[count]),distinctCOUNT(Table[Date]))
Please try this expression for a measure get your desired result (replacing Table with your actual table name)
New Measure = AVERAGEX(VALUES(Table[Date]), CALCULATE(AVERAGE(Table[Count])))
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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 |
---|---|
114 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |