Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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

8 REPLIES 8
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

Total_Score =
  ([ZM01_Score]+
  [ZM02_Score]+
  [ZM04_Score]
  )
 
Thank you
Anonymous
Not applicable

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

 

Anonymous
Not applicable

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors