Wrong Column Totals in subtable (SELECTCOLUMNS & FILTER)

[tabbey]

Hello,

I need help with the wrong column totals in my visual. 

I have created a subset of table using the SELECTCOLUMNS and the FILTER commands.

Dalsons Products = FILTER(SELECTCOLUMNS( Product, "Name", Product[Name], "Quantity Sold", Product[sold],  "Unit Price", Product[Price],  "Amount", Product[Amount],  "Year Manufactured", Product[YearMade]),  [manufacturer] = "Dalsons")

It worked fine except at the visual's Total. The "Quantity Sold" & "Amount" are showing a bigger number than what it should be. 

After 2 days of goggling, i came across potential solutions using SUMX, HasOneFilter, etc. but i was not able to get them to work.

Any suggestion?

Thank you.

Tab

[Thejeswar · Accepted solution]

Hi @tabbey,

I tried recreating your scenario.

The Below is the sample data I used

Name	Sold	Price	Amount	Yearmade	Manufacturer
A	10	100	1000	2017	Dalsons
B	5	150	750	2018	Dalsons
C	8	125	1000	2017	Dalsons
D	13	130	1690	2018	Other
E	12	110	1320	2017	Other
F	15	140	2100	2018	Dalsons
G	14	80	1120	2017	Dalsons
H	11	90	990	2018	Dalsons
I	9	70	630	2017	Other
J	7	50	350	2018	Other
K	6	30	180	2017	Dalsons
L	10	80	800	2018	Dalsons
M	5	100	500	2018	Dalsons

I create a table using the below similar code

Dalsons Products = FILTER(SELECTCOLUMNS('Product', "Name", Product[Name], "Quantity Sold", Product[sold],  "Unit Price", Product[Price],  "Amount", Product[Amount],  "Year Manufactured", Product[YearMade], "Manufacturer",'Product'[Manufacturer]), [Manufacturer] = "Dalsons")

My Output looks as shown below

 I can see that the sum of the values match to the source data. Is that what you were not able to achieve or is there something else that you were referring to?

[tabbey]

You're correct! It sounds like i had been looking at the wrong place all these times! I was able to reproduce your result. It looked like the total was wrong only if i pulled the manufacturer from the dimension. Thank you.