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