Total of multiple measures

[magtuto]

Strugling a little bit with a particular issue in relation to getting a sum from multiple measures.

I have read some information saying that calculations cannot be performed on measures.  For example I wasnt the sum of the 3 measures below.

eg. Measure 1 = Total Red Balls

      Measure 2 = Total Green Ball

      Measure 3 = Total Pink Balls

Is there anyway to do this?

[saurabhkumar]

hi,

Use CALCULATE Function to add user define measure.

Ex:-  We define 2 measure in Table1 as per need. 

Table1[Measure1]

Table1[Measure2]

Total_amt is 3rd measure which have sum of 2 measure. Yoy can add more measure sumup also.

Total_Amt = Calculate( Table1[Measure1]+Table1[Measure2])

Thanks..

[ankitpatira · Accepted solution]

@magtuto You can simply do, measure3 = measure1 + measure2

[omikeyz]

Total_Score =

  ([ZM01_Score]+

  [ZM02_Score]+

  [ZM04_Score]

  )

Thank you

[Anonymous]

Hi, this won't work if you need to sum measure between different tables. or if you want to sum a measur end a value of acolumn. 

when you start typing it only shows the measure availabel in the table you are in. 

Do you know  way around it?

Regards

[Anonymous]

Instead of total can we use measures together in a single measure?

[Anonymous]

@ankitpatira thank you so much and hope you have a great christmas time

[talha_ts]

Hi,

I understand that this is a very old question, but is there a way to calculate the sum like the totals and also generate the percentage of grand total for the above mentioned 3 measures and their numerical values. I think this was the intention of the original question.

Thanks

[Anonymous]

Is there a way to calculate the sum like the totals and also generate the percentage of grand total for the above mentioned 3 measures and their numerical values?

That is my question.

Thank you.

---

@talha_ts wrote:

Hi,

I understand that this is a very old question, but is there a way to calculate the sum like the totals and also generate the percentage of grand total for the above mentioned 3 measures and their numerical values. I think this was the intention of the original question.

Thanks

---