Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register 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
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
93 | |
85 | |
83 | |
75 | |
49 |
User | Count |
---|---|
142 | |
141 | |
110 | |
69 | |
55 |