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.
I need to Calculate some value with 2 filters:
allexcept(fileld1) and selected_filters.
How can I do it?
I want to get calculated value with one strict filter by field1 and all selected by user filters.
Thank you in advance!
The CALCULATE function takes multiple filters as an argument. You can apply the different filters that you want in the 2nd, 3rd... argument.
You may try to use ALLSELECTED Function.
When you say “selected filters by user” do you mean like a slicer? All external slicers and filters in visuals are applied to a measure automatically unless you explicitly tell the measure to ignore filters.
If you are saying "How can I retain the filters that are already applied and add new ones?" you can do that by using the VALUES function in DAX.
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 |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |