How summarize, SUMMARIZECOLUMNS or ADDCOLUMNS function sum up a column value on summarize table

[Anonymous]

Hi,

I'm a little bit confused about how these summarize functions work.

I got this table

I tried to summarize the table with comm_desc and get total saleFinaced_amt because SaleFinaced_amt is repeating the value for each record.

Finance sale = ADDCOLUMNS(SUMMARIZECOLUMNS(sale_finance_comm[SaleID], sale_finance_comm[SaleFinanced_amt], "FinanceSaleAmt",SUM(sale_finance_comm[SaleFinanced_amt])),"SaleFinanceAmt",CALCULATE(SUM(sale_finance_comm[SaleFinanced_amt])))

As you can see, it always adds up all repeating values. I don't understand why it summing all values rather than only summarized rows.

Could someone explain to me this and how can I achieve this, please?

Kind Regards

Era

[Fowmy]

@Anonymous 

When you summarize by sale_finance_comm[SaleID] and  sale_finance_comm[SaleFinanced_amt], it found two records and added to gather and you got the total of 49,000. What is your requirement here? 

I did not get why you tried to summarize your table bya value field here. Please let me know what you are trying to achieve.

[Anonymous]

Hi Fowmy,

Thanks for the reply. Now, I understand how the sum work with summarize.

I tried to write a measure to get salesfinance_amt to show with each comm_amt in a table

my measure is SUMX(ADDCOLUMNS(SUMMARIZECOLUMNS(sale_finance_comm[SaleID], sale_finance_comm[SaleFinanced_amt]),'SaleFinanceAmt',CALCULATE(SUM(sale_finance_co

mm[SaleFinanced_amt])), [SaleFinanceAmt])

I can get the correct comm_amt for each column but SaleFinaceAmt gives a total of two rows.

I need the table below

SaleID	Finance Comms	Originate Fee	Sale Finance amount
26924	1788.22	1227.27	24500.00

Hope this will explain my requirements to you. Maybe I missed some concepts here.

Kind Regards

Era

[Fowmy]

@Anonymous 

Please share some sample data in Excel along with the expected results. Do you need a table or a measure or both, plase specify. Attach your file as a link after saving in Google Srive or One Drive.