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 need to callculate an average of a Measure. It the following screen should be 46/47 but not 52
I tried with a formula that you see there but didn't work.
My measure is the one called "Actual HC"
Any ideas ?
Thanks
Solved! Go to Solution.
Ooops, sorry, I forgot that we were working with a measure already. You will need to use AVERAGEX with the <table> parameter identifying your Year-Month column. I think the following will work, but if not, let me know.
AVERAGEX( VALUES( 'YourDateTable'[Year-Month]), [Actual HC] )
where 'YourDateTable' is your date table and [Year-Month] is the column in your date table with the year-month.
https://docs.microsoft.com/en-us/dax/averagex-function-dax
Please share the DAX for [Actual HC].
Hi @RandyPgh ,
Follow :
Your illustration in the original post shows the spinners in the top-left of each visualization. This means that they are still loading. Assuming that they look the same after the spinners complete, you would need to change the Average calculation to be
Average of resource = AVERAGE( [Actual HC] )
Then put this "Average of resource" measure into the Field of the card visualization instead of the current "Actual HC". That should change the 52 to a 45.5 (if visualized with decimals).
Ooops, sorry, I forgot that we were working with a measure already. You will need to use AVERAGEX with the <table> parameter identifying your Year-Month column. I think the following will work, but if not, let me know.
AVERAGEX( VALUES( 'YourDateTable'[Year-Month]), [Actual HC] )
where 'YourDateTable' is your date table and [Year-Month] is the column in your date table with the year-month.
https://docs.microsoft.com/en-us/dax/averagex-function-dax
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 |
---|---|
90 | |
88 | |
83 | |
64 | |
49 |
User | Count |
---|---|
126 | |
110 | |
87 | |
70 | |
66 |