Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi,
Im struggling with the following, any help is much appreciated. I have a table called "Product" with information and a newly created Table called "Information" where some of the information from table "Product" needs to be placed.
Table Product
Name | Product Type | Amount |
Red | Bike | 2 |
Blue | Plane | 5 |
Black | Boat | 7 |
Red | Tree | 1 |
Black | Table | 4 |
Purple | Bike | 10 |
Purple | Plane | 2 |
Red | Bike | 4 |
Purple | Bike | 1 |
The data that i want to store in the newly created table called "Information" is the name and amount where the product type is Bike
(New) Table Information
Name | Amount |
Red | 6 |
Purple | 11 |
Thank you very much for your help.
Peter
Solved! Go to Solution.
Perhaps:
New Table =
SUMMARIZE(
FILTER('Table',[Product Type] = "Bike"),
[Name],
"Amount",SUM('Table'[Amount])
)
Perhaps:
New Table =
SUMMARIZE(
FILTER('Table',[Product Type] = "Bike"),
[Name],
"Amount",SUM('Table'[Amount])
)
@Anonymous , Try like
summarize(filter(Table,Table[Product Type]="Bike"),table[Name], "Amount", sum(Table[Amount]))
If you put a Slicer of Product Type and filter Bike and use any visual with Name and sum of Amount. you should get this
Very much appreciated Amitchandak. Will try it now.
Thanks
User | Count |
---|---|
122 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
187 | |
94 | |
67 | |
63 | |
54 |