I am struggling to find the best way to exclude slicer selection from data in reports. I have created a measure, however, the slicer selection selects the department of the company (for example, sales,finance, hr,etc) and the report shows performance of each department in compared to others. However, to calculate the attendance for example, the data comes from another table and that does not have the department column in it.
Also, I can’t really use a vlookup and add it since employees tends to have a high mobility rate. What would be the most beneficial and effective approach for such conditions?