Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
User | Count |
---|---|
103 | |
87 | |
77 | |
70 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |