Measure to Count Rows Except ignoring slicer value from another table

Anonymous you're not providing a lot of details about your data model so this is hard to answer.

 

Based on your statement "terminated employees is only pulling values for the month that the user selects instead of all employees who were terminated in that month" I'd be willing to bet that you need multiple relationships between your date table and your employees table.

 

I did something similar recently.  Employees have a hire date, termination date, and potentially a rehire date.  There needs to be a relationship for each of these dates and the date table.  In the measures for hired employees, use the USERELATIONSHIP function specifying the date table field and date hired as part of the CALCULATE statement to make sure you are counting by people hired in that time period.  Similarly, for terminated employees use the function specifying date table value and date terminated to make sure you count those termed in that period.

 

Hope this helps!

Hi littlemojopuppy ,

 

Yes, the principle of screening is the same.

Amount_filter_month =
CALCULATE (
    SUM ( FactInternetSales[SalesAmount] ),
    ALL ( DimDate[MonthNumberOfYear] ),
    ALL ( [column you want to neglect] ),
    ALL ( [column you want to neglect] )
)

 

In addition, if you want to have more understanding, you can refer to the following related blogs.

Managing “all” functions in DAX: ALL, ALLSELECTED, ALLNOBLANKROW, ALLEXCEPT - SQLBI

 

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.