Forum Discussion
Solved
List by Open Status
Hi, I need help with deriving a table of open status list of products. I have 2 tables - a master with product names and another with open/closed reorder status. Table 1 Product A1 A2 ...
Thank you for responding. unfortunately that will not work, because then this record will filter through:
| A2 | T5 | Open |
but, it has a "Closed" record in Table 2. I want only those products that do not have a "Closed" status.
abhilash_sa ,
Got it, try below DAX.
I have created a measure to filter the values. If you want to create a calcualted table then use the belwo DAX.
Table 3 =
VAR ClosedTypes =
SUMMARIZE(
FILTER(
'Table (2)',
'Table (2)'[Status] = "Closed"
),
'Table (2)'[Product], 'Table (2)'[Type]
)
RETURN
FILTER(
'Table (2)',
NOT (
'Table (2)'[Product] & 'Table (2)'[Type]
IN SELECTCOLUMNS(ClosedTypes, "Key", [Product] & [Type])
)
)
Thank you very much. Exactly the solution I needed.