Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to sum two measures?

Hello everybody, I'm trying to get the total of each measure in the table (They are not columns, but measures)

As you can see, there is no the right total value for both: [Bias+] and [Bias-] 

Once having the total for each one I'll need to sum them to have the total absolute deviation.

 

 

 

 

 

 

 

 

 

 

 

Thanks in advance for your help.

 

 

 

 

  • Hello, you may try to create measure like below:

    measure = SUMX(VALUES('COMMONDITY COMERCIAL'),[Bias-])

    It suppose will sum the total correctly.

     

    Hope this can help you.

2 Replies

  • Hello, you may try to create measure like below:

    measure = SUMX(VALUES('COMMONDITY COMERCIAL'),[Bias-])

    It suppose will sum the total correctly.

     

    Hope this can help you.

    • Anonymous's avatar
      Anonymous
      Not applicable

      Yes, it solved. Thanks a lot Chew_WenJie.