total value for each category

[Anonymous]

Hi All,

my dax doesn't go as expected when i dorill up.

dax =
DIVIDE(
sum(table1[Value1])
, sum(table2[Value2])
)

[v-kkf-msft · Accepted solution]

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]

@Anonymous , seem like you need some of Avg

Sumx(summarize(Table, Table[Category], Table[Sub Category], "_1", dax =
DIVIDE(
sum(table1[Value1])
, sum(table2[Value2])
) ), [_1])

[Anonymous]

Thanks for the help !!

But your dax is not work.

[amitchandak]

@Anonymous , If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Anonymous]

https://app.powerbi.com/reportEmbed?reportId=360d278b-4546-48ae-a71e-8bc99ba90910&autoAuth=true&ctid...

[amitchandak]

@Anonymous We can not access your app. Paste data here from excel or Power BI

or share them on onedrive or dropbox

[Anonymous]

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

[Anonymous]

category is dim1[name].

sub category is dim2[name].