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())
tex628's avatar
tex628
Icon for Community Champion rankCommunity Champion
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())
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thank you so much