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.
Hello,
I have a calculation where I want to ignore every possible filter except one. I have tried ALL() and ALLEXCEPT() and cannot get it to work. When I use ALL() for all the dimension tables, the metric is no longer filtered. When I try to remove the dimension table with the single metric I care about, it does not filter based on that metric. If I use ALLEXCEPT() with just that single metric, I still have the results filtered by other dimensions in other tables.
Here is an example. I want to calculate this and only allow it to be filtered by Dimension_LossCurves. Am I doing something wrong or do table relationships impact these functions in a way I do not understand?
Solved! Go to Solution.
Hi @rawiswarden ,
ALL() function will ignore your filters.
You could share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to OneDrive and share the link here.
Hi @rawiswarden ,
ALL() function will ignore your filters.
You could share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to OneDrive and share the link here.
Unfortuantely all the data is confidential and the data model is fairly complex, so it'd be hard to randomize. I'll just calculate this outside of Power BI for now, since I can't seem to get the behavior I'm aiming for.
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 |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |