Forum Discussion

alwong's avatar
alwong
New Member
10 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
    10 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
    10 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
10 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
10 months ago

GeraldGEmerick   You can use CROSSJOIN  for that. 

 

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