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.
amitchandak
Super User
Super UserAnonymous We can not access your app. Paste data here from excel or Power BI
or share them on onedrive or dropbox
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 - amitchandak
Anonymous , which one is category and sub category used in the first excel screenshot
category is dim1[name].
sub category is dim2[name].