FILTER("Reporting", ...) produces a list of rows from the Reporting table that match the given criteria (
- LIST([_THISROW]) then removes the current row from that list. We’re let with rows other than the current one that match the criteria.
The slice filter expression is applied to each row in the table the slice is based on. _THISROW then refers to the row currently being considered by the slice filter.
([_THISROW].[License Plate #] = [License Plate #]) matches rows in the Reporting table with a License Plate # column value that matches the current row’s License Plate # column value.