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
Anonymous
Not applicable

Sum and calculate combined

Hi all,

 

I'm having an issue with a (I would expect) simple formula. What I need is a formula that only sums the rows that matches the Key in the table. The key is a combination of sales organisation and category. I have 3 or 4 rows in each combination that should be summed up.

 

My formula is: =calculate(sum('Table'[Measure]),'Table'[Column]="SalesOrgCategory")

 

When I manually type the SalesOrg & Category combination in my formula it works out well for the related rows. However I would want it to be dynamic, as I have several Sales organisations and categories. This means that I would like the formula, for each row, to take the sales organisation and category and then use that in my formula. This does unfortunately not work.

 

Any ideas about how to do this dynamic formula?

 

Thank you in advance.

3 REPLIES 3
v-jiascu-msft
Employee
Employee

Hi @Anonymous ,

 

Could you please mark the proper answers as solutions?

 

 

Best Regards,

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Ashish_Mathur
Super User
Super User

Hi,

 

Drag whatever field you want to in your visual and then write this measure

 

Measure1 = SUM('Table'[Measure])


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Ashish_Mathur
Super User
Super User

Hi,

 

Drag what ever field you want in your visual and this simple measure should work

 

Measure1 = sum('Table'[Measure])

 

Hope this helps.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

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.