Groupby/Summarize and sum calculated Column

[Anonymous]

I have a table similar to this, I have a bar chart which contains only Name and Total Cost.

If i filter value Greater than 3500 then the bar chart should show Customer 1 = 7000 but it picksup single row and providing result as Customer 1 = 3600. (Basically it should sums up Total Cost based on Name)

Since Total Cost is a calculated Column, it was not visible when i try Groupby option.

Any Help Please.

Note: Total Cost Column is a calculated Column based on other fields

Name	Item	Per Unit	No. Unit	Total Cost
Customer 1	TV	1700	2	Sum(1700*2 = 3400)
Customer 1	Fridge	1800	2	Sum(1800*2 = 3600)
Customer 2	TV	1500	2	Sum(1500*2 = 3000)

[v-gizhi-msft · Accepted solution]

Hi,

Please try to create this calculated table:

Table 2 = SUMMARIZE('Table','Table'[Name],"Total Cost",SUMX(DISTINCT('Table'),'Table'[No. Unit]*'Table'[Per Unit]))

The result shows:

 

Hope this helps.

Best Regards,

Giotto Zhi

[Anonymous]

@v-gizhi-msft  it works thanks a lot

[amitchandak]

You can create a column

new column = [Per Unit]*[No. Unit]

New mseaure = sumx(table,table[Per Unit]*table[No. Unit])

Appreciate your Kudos.

[Anonymous]

@Greg_Deckler @amitchandak 

My need is to GroupBy "Name" and SumUp "Total Cost" which is a Calculated Column.

End result should be as below,

Name	Total Cost
Customer 1	7000
Customer 2	3000