Forum Discussion

ikhwan_tokenomy's avatar
ikhwan_tokenomy
Frequent Visitor
3 years ago
Solved

Incorrect Subtotal

Hi I have a DAX for custom measure with the formula of   Prev Day User Asset USD Latest Rate = CALCULATE(sum('user daily asset'[amount_usd_latest_rate]),PREVIOUSDAY(Dates[Date]))   The DAX...
DAX
PREVIOUSDAY
subtotal
  • daXtreme's avatar
    daXtreme
    3 years ago

    Maybe this:

    [Prev Day User Asset USD Latest Rate] =
sumx(
    values ( Dates[Date] ),
    calculate (
        SUM( 'user daily asset'[amount_usd_latest_rate] ),
        PREVIOUSDAY( Dates[Date] )
    )
)

     

daXtreme's avatar
daXtreme
Solution Sage
3 years ago

Maybe this:

[Prev Day User Asset USD Latest Rate] =
sumx(
    values ( Dates[Date] ),
    calculate (
        SUM( 'user daily asset'[amount_usd_latest_rate] ),
        PREVIOUSDAY( Dates[Date] )
    )
)