Forum Discussion
create new table with Summarize
Hi , I am new at Power BI , and I am stuck at creating a new bridge table which is dynamic from other master table with filter. I have a table ""structure"like below bag# , item# ...
Hi Anonymous,
Why do you want to make a summarize table? Depending on the visual you want you can create measure or add filters/Slicers to your reports that allow you to have the expectd quantites since the calculations are made based on context.
When you create a new table and considering you are using the summarize the resul of the full table will be the sum of all rows in this case 3 for each bag#.
You can use the summarize function to use in a measure that will then calculate the value you need.
Can you please add some addtional information about the expected result.
Regards,
MFelix
hi MFelix thanks for ur help
in my case, i need this table to connect(create relationship) with another statistics data table on the bag level .since structure table has duplicate values on both bag# and fitting# ，i could not create relationship directly.
user has the need to search / filter on fitting# then get connnected[ bag#] [qty]. in the end statistics on fitting level by using bag statistics * [qty]
yes as you said , could i create a unique list.on bag# ( table = all (stucture[bag#]) and then create a new column to summarize the [qty] on the bag# from the filtered rows of stucture table .
so i can use to create one to many relationship with extra statistics table? and what is the correct formular ?or do you know other better way ?
thanks in beforehand
eric
in my case, i need this table to connect(create relationship) with another statistics data table on the bag level .since structure table has duplicate values on both bag# and fitting# ，i could not create relationship directly.
user has the need to search / filter on fitting# then get connnected[ bag#] [qty]. in the end statistics on fitting level by using bag statistics * [qty]
yes as you said , could i create a unique list.on bag# ( table = all (stucture[bag#]) and then create a new column to summarize the [qty] on the bag# from the filtered rows of stucture table .
so i can use to create one to many relationship with extra statistics table? and what is the correct formular ?or do you know other better way ?
thanks in beforehand
eric