Forum Discussion
Calculating column based on filter on another table
Trying to simplify my model as much as possible: PRODUCTS table has a list of product_ids (which can be replicated), a season and a start and end date for the season ORDERS a list of orders, produc...
lg_analyst , No you can not use slicer value in a calculated column. You need to create a measure .
Move this calculation inside the expression part of Sumx , minx or countx
Sumx(Order, <Your code>)
Hi amitchandak thank you for replying. I can't use the formula you suggest because, as you can see from the first screenshot, I'm summing data in one table (PRODUCTS) but based on filters from that and another table (ORDERS). Can you suggest a way to work around this?
Thank you