Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join 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.

Reply
Anonymous
Not applicable

Creating Dynamic Table Based on Another Filtered Table

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.

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Problem solved.

 

Thanks.

View solution in original post

4 REPLIES 4
amitchandak
Super User
Super User

@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] ="?")

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Anonymous
Not applicable

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.

Anonymous
Not applicable

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

 

Anonymous
Not applicable

Problem solved.

 

Thanks.

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.