Creating Dynamic Table Based on Another Filtered Table

[Anonymous]

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.

[amitchandak]

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

[Anonymous]

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]

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 · Accepted solution]

Problem solved.

Thanks.