Aggregate Data in a total

[bilingual]

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	Date	Numbers
1	Jan-23	144
2	Jan-23	1444
3	Jan-23	4432
4	Jan-23	35656

[Idrissshatila]

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

[bilingual]

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

[Idrissshatila]

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

[bilingual]

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.