Forum Discussion

dinomaster's avatar
dinomaster
Frequent Visitor
9 years ago
Solved

Cumulative measure by type and time! Help!

Hi,   I'm having a problem with finding the right way to add a cumulative measure. So here's what's going on.   I have a table "Apps" where I have several types os Apps (A, B, C, D) and I need to...
Need Help
  • v-caliao-msft's avatar
    v-caliao-msft
    9 years ago

    Hi dinomaster,

     

    You could add another logic in your filter function.

    TypeACumulativeTotal = CALCULATE(SUM(Apps[Amount]),FILTER(ALL(Apps),AND(Apps[Type]="A",Apps[Date]<=MAX(Apps[Date]))))

     

    Regards,

    Charlie Liao

v-caliao-msft's avatar
v-caliao-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi dinomaster,

 

You could add another logic in your filter function.

TypeACumulativeTotal = CALCULATE(SUM(Apps[Amount]),FILTER(ALL(Apps),AND(Apps[Type]="A",Apps[Date]<=MAX(Apps[Date]))))

 

Regards,

Charlie Liao