Forum Discussion

Vamshi2020's avatar
Vamshi2020
Icon for Helper II rankHelper II
5 years ago
Solved

Cumulative not working with sumx

I have a Table with few columns such as member id, start date, end date , provider name etc, value etc...my value column is a calculated column with value=1 formula. so this column contains 1 for all...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Vamshi2020 

    I think you want to calculated the sum for each member id.

    Due to I don't know your data model, I build a sample to have a test.

    Sample:

    I think you want to get Sum for ID 1 = 2, Sum for ID 2 =1, Sum for ID 3 =2.

    Measure:

    Cumulative = SUMX(FILTER(ALL('Table'),'Table'[ID]=MAX('Table'[ID])),'Table'[Value])

    Result is as below:

    Calculated column:

    Sum value for each id = SUMX(FILTER('Table','Table'[ID]=EARLIER('Table'[ID])),'Table'[Value])

     Result is as below.

    Best Regards,

    Rico Zhou

     

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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Vamshi2020 

I think you want to calculated the sum for each member id.

Due to I don't know your data model, I build a sample to have a test.

Sample:

I think you want to get Sum for ID 1 = 2, Sum for ID 2 =1, Sum for ID 3 =2.

Measure:

Cumulative = SUMX(FILTER(ALL('Table'),'Table'[ID]=MAX('Table'[ID])),'Table'[Value])

Result is as below:

Calculated column:

Sum value for each id = SUMX(FILTER('Table','Table'[ID]=EARLIER('Table'[ID])),'Table'[Value])

 Result is as below.

Best Regards,

Rico Zhou

 

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