March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
HI,
I am not sure how to get the average of a measure.
Currently: Total = count (table1[ID])
And I have the following:
I would like to get the average of the all these months to show just one number say in a KPI report: 29K
Can someone please help?
Thanks in advance.
Solved! Go to Solution.
@Anonymous
Try with:
Average = AVERAGEX(VALUES(Table1[Date].[Month]),[Total])
Regards
Victor
Hi @Anonymous,
Assuming that:
=AVERAGEX(SUMMARIZE(Calendar,Calendar[Month],"ABCD",COUNT(Table1[ID])),[ABCD])
@Anonymous
Hi, try with
Average = AVERAGEX(VALUES(Table1[Category]),[Total])
Regards
Victor
Lima - Peru
Thanks for your suggestion.
Do I have to do something with the [Category]?
My data fields are "date", ID"
So currently, the return result doesn't work out.
@Anonymous
Try with:
Average = AVERAGEX(VALUES(Table1[Date].[Month]),[Total])
Regards
Victor
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
90 | |
89 | |
85 | |
73 | |
49 |
User | Count |
---|---|
167 | |
149 | |
93 | |
72 | |
58 |