cancel
Showing results for
Did you mean:  Helper I

## Total of multiple measures

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?

1 ACCEPTED SOLUTION  Community Champion

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

7 REPLIES 7 Frequent Visitor

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..  Community Champion

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

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
Not applicable

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

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

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 Regular Visitor

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 Announcements #### Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories. #### Power BI Dev Camp - September 30th, 2021  