Forum Discussion
Filter table based on another table
Hi, I would like to filter numbers out based on if they exist in another table. Example given. Table 1 consist ID Text Field Table 2 consist ID I'd like to filter Table...
Anonymous,
Use the DAX below instead.Table = CALCULATETABLE(Table1;EXCEPT(VALUES(Table1[ID]);VALUES(Table2[ID])))
Regards,Lydia
Anonymous,
Use the DAX below instead.
Table = CALCULATETABLE(Table1;EXCEPT(VALUES(Table1[ID]);VALUES(Table2[ID])))
Regards,
Lydia
What if I want to keep the values in table 2 and filter out the remaining values from table 1?
I believe you can use INTERSECT instead of EXCEPT
Anonymous I am trying to do something similar, but do not want to build another table. Instead, I want to calculate measures based on the filter that will be visualized on a matrix in a report. For example:
Table AID Cost Revenue 11 2 4 12 3 5 13 3 7 14 5 11 Table B (discontinuation)
ID 11 12 Matrix on report:
Before Disc After Disc Total Cost 13 8 Total Revenue 27 18 Any recommendations? Thank you!!
