Forum Discussion
Total by 3 categories
Hi, i have a test table:
| ID Nrb | Country | Scenario | Share |
| 363331 | Australia | Actual | 1.00 |
| 363331 | China | Actual | 1.00 |
| 363331 | Denmark | Actual | 1.00 |
| 363331 | Indonesia | Actual | 1.00 |
| 363331 | India | Actual | 1.00 |
| 363331 | Japan | Actual | 1.00 |
| 363331 | Canada | Actual | 1.00 |
| 363331 | Finland | Actual | 1.00 |
| 363331 | Norway | Actual | 1.00 |
| 363331 | Singapore | Actual | 1.00 |
| 363331 | Germany | Actual | 1.00 |
| 363331 | Spain | Actual | 1.00 |
| Total | 1.00 |
I want to have a total share group by those 3 colums like 12
Hi Anonymous,
You can try to use the following measure formulas, I add a variable with summarize function to aggregate value based on categories and use the iterator function to apply these second aggregations to summary previous results.
formula = VAR summary = SUMMARIZE ( ALLSELECTED ( Table ), [ID Nrb], [Country], [Scenario], "_Share", [Share] ) RETURN SUMX ( summary, [_Share] )Regards,
Xiaoxin Sheng
4 Replies
Hi Anonymous,
You can try to use the following measure formulas, I add a variable with summarize function to aggregate value based on categories and use the iterator function to apply these second aggregations to summary previous results.
formula = VAR summary = SUMMARIZE ( ALLSELECTED ( Table ), [ID Nrb], [Country], [Scenario], "_Share", [Share] ) RETURN SUMX ( summary, [_Share] )Regards,
Xiaoxin Sheng
ryan_mayuSuper User
Anonymous
is share column a measure?
if not, when you set share as sum, you should get 12
- ryan_mayu
Anonymous
maybe you can try this
measure = sumx('Table',[share])