Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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?
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?
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
78 | |
65 | |
60 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |