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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.