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
bilingual
Helper V
Helper V

Aggregate Data in a total

Hi, i have a Data sheet, which is similar to :

I would like to create Type which is "TOTAL"  - all Data numbers aggregated so for example i can compare Type 1 with the "TOTAL", which is the best way?

 

Type DateNumbers 
1Jan-23144
2Jan-231444
3Jan-234432
4Jan-2335656
4 REPLIES 4
Idrissshatila
Super User
Super User

Hello @bilingual ,

 

You could create a new measure that looks like this

 

Total  = Sum( Tablename[Numbers] )

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Thanks, will it be dynamic according year and month and not just create a total with no regards to date?

Hello @bilingual ,

 

yes true, if you click any year or month the data will change according to the selected.

 

If I answered your question, please mark my post as solution, Appreciate your Kudos  👍

Follow me on Linkedin



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Im sorry but the challenge is that i use a filter for the report so only one Type figures, for example Type 2.

But i  still need to compare it to the Total sum.

I think i need to use condittional Total with some formula like CALCULATE, ALL etc.

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.