Forum Discussion

Anno2019's avatar
Anno2019
Icon for Helper IV rankHelper IV
7 years ago
Solved

Sum up a calculated column result

Hi Guru's

I thought this was easy but clearly I have not taken something into consideration.

 

I have a calculated column which determines the [Trend] of a customer.  Which could be Lost, New, Growth or De Growth.

What I am trying to achieve is to create a calculated measure which will tell me what the value for each trend is.  Basically 1 calculated measure for each trend which should have a total based on the variance.  

You will notice that the value @ a row-level works but the TOTAL for the column is 0.  What am I doing wrong?

I include below a screenshot of the issue and include a link to the pbix file i am using for this example.

 

https://www.dropbox.com/s/1oo1xm2siv9yccm/Trending_Test%20Data.pbix?dl=0 

Need Help
  • parry2k's avatar
    parry2k
    7 years ago

    Anno2019 update your Lost measure to this

     

    Lost = 
SUMX( VALUES( 'DATA Sheet'[Customer Name] ),
IF(
    [Trend]="Lost",
    [Var],
    0
)
)

2 Replies

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    7 years ago

    Anno2019 update your Lost measure to this

     

    Lost = 
SUMX( VALUES( 'DATA Sheet'[Customer Name] ),
IF(
    [Trend]="Lost",
    [Var],
    0
)
)