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
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 A
| ID | 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!!