Forum Discussion
total value for each category
Hi All, my dax doesn't go as expected when i dorill up. dax = DIVIDE( sum(table1[Value1]) , sum(table2[Value2]) )
Hi Anonymous ,
Please try the following formula:
Measure = SUMX ( SUMMARIZE ( Table1, dim1[name], dim2[name], "SubValue", [dax] ), [SubValue] )If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Table１
key1key2key3value
| 001 | 011 | 101 | 1 |
| 002 | 012 | 102 | 2 |
| 003 | 013 | 103 | 3 |
| 004 | 014 | 104 | 4 |
| 005 | 015 | 105 | 5 |
| 001 | 012 | 102 | 10 |
| 001 | 013 | 104 | 40 |
table2
key1key2value
| 001 | 011 | 10 |
| 001 | 012 | 20 |
| 001 | 013 | 30 |
| 002 | 014 | 40 |
| 002 | 012 | 60 |
dim1
key name
| 001 | aaa |
| 002 | bbb |
| 003 | ccc |
| 004 | ddd |
| 005 | eee |
dim2
key name
| 011 | AAA |
| 012 | BBB |
| 013 | CCC |
| 014 | DDD |
| 015 | EEE |
dim3
key name
| 101 | A |
| 102 | B |
| 103 | C |
| 104 | D |
| 105 | E |
Anonymous , which one is category and sub category used in the first excel screenshot
category is dim1[name].
sub category is dim2[name].