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

Hi ikhwan_tokenomy 

 

What should the logic be behind this measure? How do you want to aggregate? You've not shown this... And please always remember that one picture is worth a thousand words 🙂

ikhwan_tokenomy's avatar
ikhwan_tokenomy
Frequent Visitor
3 years ago

Hi daXtreme 

I've edited my question to show an example. Hope it is clearer now

THanks

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