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 III

How to do Sum of a measure and column value

Hi There,

I am struggling to create a simple calculation and it might be sound so silly but please help me.

I am trying to create Sum of two values(A+B) in which A is a calculative Measure and B is Column present in data.

Please see below data with desire result:

Thanks

Ashish

1 ACCEPTED SOLUTION
Helper III

Hi @Anand24

So i have just created one more meausre where i took the Sum of that Sales Column

Measure_2=sum(Sales)

and then i simply added both of the measures:

Total =[Cummulative Total]+[Measure_2]

Regards,

Ashish

9 REPLIES 9
Super User

@ashc_cool10 ,
Please post your solution here and mark it as a solution so that others with similar issue would find help !

 Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!!Proud To Be a Super User !!!LinkedIn

Helper III

Hi @Anand24

So i have just created one more meausre where i took the Sum of that Sales Column

Measure_2=sum(Sales)

and then i simply added both of the measures:

Total =[Cummulative Total]+[Measure_2]

Regards,

Ashish

Super User

Hi @ashc_cool10 ,
Try the below DAX in a new measure:

`Total = [Cummulative Total] + SUM(Sales)`

This is with an assumption that "Cummulative Total" is name of calculated measure and "Sales" is the name of column.

 Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!!Proud To Be a Super User !!!LinkedIn
Helper III

Hi @Anand24 ,

I already treid this but values are not coming right.

here [Better RT] is measure and HSLVT is our column which is available in data

54014036.1+49327817=103341853

here vlaues in Total_2 in row 1st should appear 54014036.1+49327817=103341853

Super User

Hi,

Regards,
Ashish Mathur
http://www.ashishmathur.com
Helper III

I am able to solve this issue but thanks again for your prompt resposne.

Thanks,

Ashish

Super User

You are welcome.

Regards,
Ashish Mathur
http://www.ashishmathur.com
Super User

@ashc_cool10 Check the implicit aggregation on HSLVT in your table. Make sure it is Sum and not something like Min or Max or Average. If it is, then change SUM to MIN, MAX, AVERAGE, etc.

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...
Helper III

It was in SUM only and fortuantely i am able to solve that issue.

Cheers!

Ashish

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 - August 2024

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

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Fabric Community Update - September 2024

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

Top Solution Authors
Top Kudoed Authors