Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
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 👍
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 👍
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.
User | Count |
---|---|
128 | |
108 | |
99 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |