topic Re: Incorrect Subtotal in DAX Commands and Tips

Incorrect Subtotal

ikhwan_tokenomy — Fri, 09 Sep 2022 02:50:14 GMT

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 will give result like below. Where the prev day value of each day is correct, but on the subtotal of the month, its showing the previous day record of the first date instead of the SUM of all the prev day value.

How can this be fixed?

Thanks

Re: Incorrect Subtotal

daXtreme — Thu, 08 Sep 2022 08:46:42 GMT

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 🙂

Re: Incorrect Subtotal

ikhwan_tokenomy — Fri, 09 Sep 2022 02:50:53 GMT

Hi daXtreme

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

THanks

Re: Incorrect Subtotal

daXtreme — Fri, 09 Sep 2022 07:10:49 GMT

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

Re: Incorrect Subtotal

ikhwan_tokenomy — Mon, 12 Sep 2022 03:37:29 GMT

Thanks daXtreme