Using ALLCROSSFILTERED with CALCULATE
According to the documentation (https://docs.microsoft.com/en-us/dax/allcrossfiltered-function-dax) I should be able to use ALLCROSSFILTERED within a CALCULATE, but I'm getting an error that it failed to resolve name 'ALLCROSSFILTERED' in the following measure: Count All Employees = CALCULATE(SUM('Employee Dim'[Custodian Count]), ALLCROSSFILTERED('Employee Dim')) Can someone help me here? In the end, what I am trying to do is select the name of the person from the Employee dimension for the USERNAME() that is logged in, so I need to remove all the filters that may have been applied. The ALL() function only does it for filters applied directly to that table and not for any related tables.