Forum Discussion
Solved
Using a Table to call value into a filter
Hi There. I hope you are having a good day. This is the context: The report i'm working on has "Sales Divisions" and each one is defined differently which requires me to filter them so I get the...
alwong Sure, you could do something like the following:
Product Table = UNION ( GENERATE( { "SalesDivision1" }, {Product1, Product2, Product3,...,ProductN} ), GENERATE( { "SalesDivision2" }, {Product1, Product2, Product3,...,ProductN} ), GENERATE( { "SalesDivision3" }, {Product1, Product2, Product3,...,ProductN} ), ... )GeraldGEmerick You can use CROSSJOIN for that.
alwong you cannot dynamically create calculated tables. You can only create table variables inside measures.
Hi,
You could create a Sales division calculated column in t he Fact table to fetch data from the product table based on the Product lookup value. You may se the LOOKUPVALUES()/CALCULATE()/RELATED() function to do so. To receive more help, share some data to work with and show the expected result. Share data in a format that can be pasted in an MS Excel file.