Forum Discussion

alwong's avatar
alwong
New Member
9 months ago
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...
Need Help
Show and Tell
Tips and Tricks
  • GeraldGEmerick's avatar
    GeraldGEmerick
    9 months ago

    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} ),
  ...
)
  • lbendlin's avatar
    lbendlin
    9 months ago

    GeraldGEmerick   You can use CROSSJOIN  for that. 

     

    alwong you cannot dynamically create calculated tables. You can only create table variables inside measures.

GeraldGEmerick's avatar
GeraldGEmerick
Super User
9 months ago

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} ),
  ...
)
lbendlin's avatar
lbendlin
Super User
9 months ago

GeraldGEmerick   You can use CROSSJOIN  for that. 

 

alwong you cannot dynamically create calculated tables. You can only create table variables inside measures.