Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
How to get the Average value with rows
As you can see in the table below. I want get the average value for each row.
I have tried so many things.
But this give me the SUM.
I also would like to get median value as well.
Color | City 1 | City 2 | City 3 | Avreage |
Yellow | 2 | 7 | 6 | 5 |
Blue | 10 | 10 | 10 | 10 |
Green | 12 | 89 | 57 | 52,66667 |
I hope the comunity can help me 🙂
Solved! Go to Solution.
@Anders_Dahl , do you have these cities as separate columns? I would unpivot them first, otherwise you'll have to define each value with SELECTEDVALUE, for example AVERAGEX(Table, SELECTEDVALUE ( Table[City 1] )+ ... ).
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your Kudos.
Check out my latest demo report in the data story gallery.
Stand with Ukraine!
Here are official ways you can support Ukraine financially (accounts with multiple currencies):
1) Support the Armed Forces of Ukraine: https://bank.gov.ua/ua/about/support-the-armed-forces
2) Come Back Alive foundation: https://www.comebackalive.in.ua/
Thank you!
@Anders_Dahl , do you have these cities as separate columns? I would unpivot them first, otherwise you'll have to define each value with SELECTEDVALUE, for example AVERAGEX(Table, SELECTEDVALUE ( Table[City 1] )+ ... ).
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your Kudos.
Check out my latest demo report in the data story gallery.
Stand with Ukraine!
Here are official ways you can support Ukraine financially (accounts with multiple currencies):
1) Support the Armed Forces of Ukraine: https://bank.gov.ua/ua/about/support-the-armed-forces
2) Come Back Alive foundation: https://www.comebackalive.in.ua/
Thank you!
I did use the unpivot and then i used Averagex and filter togheter and it worked perfect.
Whit this i understand how work with the tables.
So thanx!
Hi @Nate123
Yes i can, but i want this to be dynamic.
I want to know why this is acting like it does. I can use other DAX to get the average.
Could you sum them and divide by 3?
User | Count |
---|---|
57 | |
22 | |
21 | |
19 | |
16 |
User | Count |
---|---|
87 | |
85 | |
52 | |
37 | |
23 |