Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
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.
For others who may have this question, I have a partial solution:
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
19 |