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,
I want to calculate the Average (mean) of the 2020 and 2021 based on the values on the above table.
Example: (3792 + 3082 + 3337 + 3199) / 4
Any help!
thank You
Solved! Go to Solution.
You don't show the model, so I can only give you a very general formula...
[Measure] =
AVERAGEX(
DISTINCT( T[Month] ),
[Your Base Measure]
)
Please try measure as:
Measure =
CALCULATE(
AVERAGEX(DISTINCT(Sub_main [Month]),Sub_main [Total]),
ALL('Table')
)
Best Regards,
Link
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Please try measure as:
Measure =
CALCULATE(
AVERAGEX(DISTINCT(Sub_main [Month]),Sub_main [Total]),
ALL('Table')
)
Best Regards,
Link
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Where do you want to see the average? In the total row or on a card visual. Show the expected result very clearly. Also, share the link from where i can download your PBI file.
You don't show the model, so I can only give you a very general formula...
[Measure] =
AVERAGEX(
DISTINCT( T[Month] ),
[Your Base Measure]
)
Dear Daxer,
I used the formula you suggested however, i am getting the same values as the first column.
1) Total = SUM(Sub_main[2021])
2) Measure = AVERAGEX( DISTINCT(Sub_main[Month] ), Sub_main[Total]).
thank you
maybe you can try
VAR _max=calculate(max(date),all(table))
return divide(calculate(sum(value),filter(all(table),year(date)=2021)), month(_max))
Proud to be a Super User!
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 |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |