Forum Discussion
Solved
how to filter a table visual
Hi, I have 3 tables- customers, products and sales. My table visual has the following columns from: customer- customer name, customer id; products- product id, product name, product ...
You can create a calculated column in the sales table:
IsCustomerNotSalesRep =
IF (
RELATED(Customers[customer name]) <> Sales[sales rep name],
1,
0
)Once you have the calculated column, you can apply a filter to your table visual to only include rows where this column is 1.
You are a legend!!!! Thank you so much.