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.
Dear All,
How to Calculate Average Of Total in Power BI. for Example
Item | Quantity | AvgOf Total -Sum(Quantity)/NoOfRows |
Item1 | 10 | 9 |
Item2 | 12 | 9 |
Item3 | 9 | 9 |
Item4 | 8 | 9 |
Item5 | 6 | 9 |
this Exampe is 5 Item and Quantity is (10+12+9+8+6)=45 which devided is NoOfRows is 5 Total Values is 9 in every Rows. how to achieve this please suggest.
Solved! Go to Solution.
Hi @vijayit43,
Use following steps:
1. Create a new measure.
2. Use below DAX. Replace Table1 with your table name.
AverageofTotal = VAR Countofrows = CALCULATE(COUNTROWS(Table1),ALL(Table1)) VAR TotalQuantity = CALCULATE(SUM(Table1[Quantity]),ALL(Table1)) RETURN CALCULATE(DIVIDE(TotalQuantity,Countofrows,0),ALL(Table1[Item]) )
Prateek Raina
Just create a new measure with formula
Average = CALCULATE(AVERAGE('Table'['Column']),ALLSELECTED('Table'))
If you want to round the average to a certain number of digits, just do
Average = CALCULATE(ROUND(AVERAGE('Table'[Column]), 'Number of Digits' ),ALLSELECTED('Table'))
Thank You jashan.
Hi @vijayit43,
Use following steps:
1. Create a new measure.
2. Use below DAX. Replace Table1 with your table name.
AverageofTotal = VAR Countofrows = CALCULATE(COUNTROWS(Table1),ALL(Table1)) VAR TotalQuantity = CALCULATE(SUM(Table1[Quantity]),ALL(Table1)) RETURN CALCULATE(DIVIDE(TotalQuantity,Countofrows,0),ALL(Table1[Item]) )
Prateek Raina
dear prateek,
I want to take average amount to circle places only.in table when apply "total" to all fields.
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 |
---|---|
107 | |
100 | |
80 | |
63 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |