sum of the value from chart

[Kim_Sky]

Hi,

I was using the dax below to calculate my previous week value, and in the pic 1 suppose shown the sum of pic 2 after drill down in the graph. 

Previous Week Electricity = calculate(sum(Electrical[Value]),FILTER(all('Calendar'),'Calendar'[Date]=MAX('Calendar'[Date])-7))

But I have no idea or maybe the dax formula i using is wrong, why the value is not total but only shown the sunday value. How should I change that? 

Thanks for your help. 

(pic 1)(pic 2)

[v-yanjiang-msft · Accepted solution]

Hi @Kim_Sky ,

According to your description, I create a sample.

Electrical table:

Calendar table with its week num.

Here's my solution, create a measure:

Previous Week Electricity =
IF (
    ISINSCOPE ( 'Calendar'[Week Num] ),
    CALCULATE (
        SUM ( Electrical[Value] ),
        'Calendar'[Week Num]
            = MAX ( 'Calendar'[Week Num] ) - 1
    ),
    CALCULATE (
        SUM ( Electrical[Value] ),
        FILTER ( ALL ( 'Calendar' ), 'Calendar'[Date] = MAX ( 'Calendar'[Date] ) - 7 )
    )
)

Get the correct result.

I attach my sample below for your reference.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[nvprasad]

Hi Kim_Sky,

As you see in below DAX mentioned by you, you are trying to filter maxdate - 7 means only one day. 

Previous Week Electricity = calculate(sum(Electrical[Value]),FILTER(all('Calendar'),'Calendar'[Date]=MAX('Calendar'[Date])-7))

Appreciate a Kudos! ‌‌
If this helps and resolves the issue, please mark it as a Solution! ‌‌

Regards,
N V Durga Prasad

[Kim_Sky]

Hi @nvprasad 

I have try to using calendar [week num] for calculate one week before, but in the graph for daily the value won't be changed. 

Are there any recommended dax that I can use?

Thanks for your help