Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi, struggling with this.
I have a table called t_Product_Types which consists of a list of product types, say, A,B,C, so t_Product_Types with a text field called Product_Type.
I also have a table called t_Sales which consists of two fields, Sales_Type and Sales_Volume. Sales_Type is one of the types listed in t_Product_Types and Sales_Volume is a simple number.
I have a filter on the Product_Types in t_Product_Types visible as a slicer.
What I want to do is to dynamically create a table, consisting of the Product_Type and Sales_Volume values based on the Product_Types filtered.
So, something like,
t_New_Table = FILTER(SUMMARIZECOLUMNS(t_Sales[Sales_Type],t_Sales[Sales_Volume]),"BIT I CAN'T FIGURE OUT")
This is a rather condensed and simplified version of what I am trying to do but hopefully makes sense.
Many thanks.
Solved! Go to Solution.
@Anonymous , Description you provided not making it clear is product and sales-type are related. If sales type is subset or product type then you can join those
t_New_Table = FILTER(SUMMARIZE(proudctType,productType[Type],t_Sales[Sales_Type],t_Sales[Sales_Volume]),[Type] ="?")
Yes, the values in the Sales_Type column in the t_Sales table will all be from the Product_Type field in the t_Product_Types table.
Not sure what you mean by Join.
Relatively new to this.
I have, hopefully, shared a link to a Google Drive with an example file. Wording is different. t_Names contains a list of names. t_Names can be filtered. t_Scores contains a set of test scores. t_Summary is a dynamic table created using SUMMARIZECOLUMNS. I want t_Summary to only contain data for the names that are filtered.
https://drive.google.com/open?id=15TlcJI-GwJdt7ZEHHgrUiXY_nfEonqz7
Problem solved.
Thanks.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
76 | |
71 | |
56 | |
39 | |
35 |
User | Count |
---|---|
66 | |
66 | |
59 | |
53 | |
45 |