cancel
Showing results 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

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

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

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

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

Announcements

#### 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 Monthly Update - June 2024

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

#### 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
Top Kudoed Authors