Forum Discussion
lg_analyst
Helper I
Helper ICalculating 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...
amitchandak
Super User
Super Userlg_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>)
lg_analystHelper I
Helper IHi 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