Forum Discussion
DAX Average
Hi Everyone,
I have a dataset as shown below :
| Row_Number | grantedamount | WeightedGranted |
| 1 | 450000 | 1350000 |
| 2 | 225000 | 675000 |
| 3 | 180000 | 540000 |
| 4 | 180000 | 1260000 |
| 5 | 135000 | 405000 |
| 6 | 135000 | 540000 |
| 7 | 112500 | 562500 |
| 8 | 90000 | 450000 |
| 9 | 90000 | 450000 |
| 10 | 67500 | 270000 |
| 1 | 112500 | 1260000 |
| 2 | 90000 | 405000 |
| 3 | 90000 | 540000 |
| 4 | 112500 | 562500 |
| 5 | 90000 | 1260000 |
| 6 | 90000 | 405000 |
| 1 | 112500 | 540000 |
| 2 | 90000 | 562500 |
| 3 | 90000 | 1260000 |
| 4 | 112500 | 405000 |
I currently already have a simple measure that divides one into the other :
Granted Weighted Average = sum('Average'[WeightedGranted]) / sum('Average'[grantedamount])
However What I want to do now is the same sum but so it doesn't include row numbers from 1-3. Basically all values i've highlighted in red so anything thats >=4 onwards.
Can anyone help?
Thank you in advance
Try this,
Granted Weighted Average = VAR Weighted = CALCULATE( SUM('Average'[WeightedGranted]) , 'Average'[RowNumber] > 3) VAR Granted = CALCULATE( SUM('Average'[grantedamount]) , 'Average'[RowNumber] > 3) Return DIVIDE( Weighted , Granted , BLANK())
3 Replies
Try this,
Granted Weighted Average = VAR Weighted = CALCULATE( SUM('Average'[WeightedGranted]) , 'Average'[RowNumber] > 3) VAR Granted = CALCULATE( SUM('Average'[grantedamount]) , 'Average'[RowNumber] > 3) Return DIVIDE( Weighted , Granted , BLANK())Anonymous , Try like
Granted Weighted Average =calculate( divide(sum('Average'[WeightedGranted]) , sum('Average'[grantedamount])), 'Average'[Row_Number] >3)
Granted Weighted Average =calculate( divide(sum('Average'[WeightedGranted]) , sum('Average'[grantedamount])), filter('Average','Average'[Row_Number] >3))
