Forum Discussion
vyacheslavg
7 years agoHelper II
Union filter in Power Query or DAX
Hello, I have a very simple filtering task (conceptually). But can't figure out how to apply combined filter to a very simple dataset. Original dataset Item ...
- Anonymous7 years ago
What about something like this?
So Items 1 and 6 have all ABC, but item 3 does not since ABC happened in one row, but if that needs to be accounted for can change the code easily.
ALL ABC Check = var __CurrentID= Table1[Item] RETURN Var __NewColumn= CALCULATE( CONCATENATEX( 'Table1', 'Table1'[Added by]), FILTER( 'Table1', Table1[Item] = __CurrentID ) ) RETURN IF( AND( LEN(Table1[Added by]) =1, SEARCH("A",__NewColumn,,0)+SEARCH("B",__NewColumn,,0)+SEARCH("c",__NewColumn,,0) >= 3 ), "ALL ABC", "Missing" )
vyacheslavg
7 years agoHelper II
This is my Power Query solution, quite clumsy.
I think this has some elegant solution in DAX.
Filtered rows to A, B and C in column "Added by".
Kept duplicates in "Item" column
This is a quite acceptable solution, but all my attempts with DAX (filter, calculatetable, etc.) - no success.