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.

v-tejrama's avatar
v-tejrama
Community Support
9 months ago

Hi alwong ,

 

Thank you Ashish_Mathur and GeraldGEmerick for the response provided!


Has your issue been resolved? If the response provided by the community member addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.


Thank you for your understanding!

v-tejrama's avatar
v-tejrama
Community Support
9 months ago

Hi alwong ,

 

I wanted to follow up and see if you had a chance to review the information shared. If you have any further questions or need additional assistance, feel free to reach out.

Thank you.