Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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 4...
General Comment
Need Help
  • tex628's avatar
    tex628
    6 years ago

    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())
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

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))