Forum Discussion
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 faile...
For others who may have this question, I have a partial solution:
Logged In User = CALCULATE(SELECTEDVALUE('Employee Dim'[Custodian Name]),FILTER(ALL('Employee Dim'),[Custodian Email]=USERPRINCIPALNAME()),ALL('Connected Client Fact'))
By using a second filter on the central Fact table I was able to remove any crossfiltering that was occuring on the Employee dimension.
You'll note that this solution is predecated on the point that there is a central table. This would not have worked if I needed data from the Fact table. If that were the case I would need to remove all the filters individually from each connected dimension.
I hope an expert can tell me why ALLCROSSFILTERED is not working.
I'm experiencing the same issue. One assumption of mine is that it has to do with the version of the SSAS which has not been updated with the latest cumulative updates and thus not supports the newest DAX functions listed here: https://docs.microsoft.com/en-us/dax/new-dax-functions