Forum Discussion

lastnn30's avatar
lastnn30
Post Patron
3 years ago
Solved

Table does not summarize

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 ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    3 years ago

    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.

ddpl's avatar
ddpl
Solution Sage
3 years ago

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])