DAX measure or column formula

[rommel20]

I want to achieve the GREEN one, Whwen i click the Slicer the 1st descript on (4 rows) I got the correct Sum of G, Sum of E and Sum of G&E.

But when I Click 2  Desc (8 rows) , Sum of G was added and SUm of E resulting to get a different value of SUM of G&E

[v-yuezhe-msft]

@rommel20,

What logic do you use to calculate “Sum of G&E”? I am not sure that how you get 25238316 and 54425440 based on the data in your screenshot. Could you please share raw data of your table and post the formula you use to calculate “Sum of G&E”?

Regards,
Lydia

[rommel20 · Accepted solution]

25238316 is  the product of Sum of G and Sum of E. Actually I found a soution using SUMMARIZE table 

Final = SUMMARIZE(Table,Table[Property],"Total",[Total Sum of G and E])

and I used this summarize table to create new measure to SUM up 2 different  Property

[v-yuezhe-msft]

@rommel20,

Glad to hear the issue is solved, you can accept your reply as solution, other community members would benefit from your solution when they get same issues.

Regards,