Forum Discussion

APini's avatar
APini
New Member
9 years ago
Solved

Cumulative Sales

I want to write a measure which filters the data by multiple columns.   I want a cumulative total for a product over the course of twelve weeks and then I want to have a measure which shows the per...
Need Help
  • vitinho's avatar
    vitinho
    9 years ago

    Hi,

    Did you try?
    = CALCULATE(SUM('table'[value]) ,
                           FILTER(ALL('table'),
                                      AND(table[week number]<=MAX('table'[week number]),
                                              table[Sales Person] = "Dave"),
                           VALUE('table'[Product]))


vitinho's avatar
vitinho
Helper I
9 years ago

Hi,

Did you try?
= CALCULATE(SUM('table'[value]) ,
                       FILTER(ALL('table'),
                                  AND(table[week number]<=MAX('table'[week number]),
                                          table[Sales Person] = "Dave"),
                       VALUE('table'[Product]))


  • APini's avatar
    APini
    New Member
    9 years ago

    That's great thanks it's worked.