Table does not summarize

[lastnn30]

Hi

I have 3 tables and I merge them using PQ. Now I want to create a table in PowerBI which shows SalesPerson and Amount (Net).

When I creat a table, it wont summerize (add). For example, I expect Power Bi will add all Liz's transcations and give one number instead of 4. Also the Grand total is not added automatically in my table. Thank you very much.

PS: the Power BI file is here

https://drive.google.com/file/d/1XVIJgkdbRpouHIhjJv_U3GfUFp9KeLy0/view?usp=sharing

[lastnn30]

Thank you very much.

[Ashish_Mathur]

You are welcome.

[ddpl]

@lastnn30 Hi First change relationship as from Single to Both as per below snap:

Then create measure as per below:

Measure  = var _S = SUM('Table (2)'[Amount])
var _C = SUM('Table (2)'[Amount]) * MIN('Table (3)'[Commision])
var _F = _S - _C
return
_F

finally  create table as per below:

Table = SUMMARIZE('Table', 'Table'[SalesPerson], "Raq" ,[Measure])

[Ashish_Mathur]

Hi,

Share the download link of the file 8.xlsx

[lastnn30]

Thank you. Here is the link

https://docs.google.com/spreadsheets/d/1k1rwg1ymxiQHVSUyCO9C7VW5NutT8CIe/edit?usp=sharing&ouid=10039...

Thanks again

[Ashish_Mathur · Accepted solution]

Hi,

Download the PBI file from here.  The data type of he net column was Text.  I changed it to Decimal in the Query Editor an wrote a simple SUM measure.

Hope this helps.

Also, changed one relationship (this is not required thought because you have merged data from all tables to just 1.