Forum Discussion
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 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
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.
6 Replies
Hi,
Share the download link of the file 8.xlsx
Thank you. Here is the link
Thanks again
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.
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
_Ffinally create table as per below:
Table = SUMMARIZE('Table', 'Table'[SalesPerson], "Raq" ,[Measure])
Thank you very much.
You are welcome.
