cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
magtuto
Helper I
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
ankitpatira
Community Champion
Community Champion

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

View solution in original post

7 REPLIES 7
saurabhkumar
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..

 

ankitpatira
Community Champion
Community Champion

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

View solution in original post

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

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

 

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

 




Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors