Use 2 filters in calculate

[Ustinovdl]

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!

[vega]

The CALCULATE function takes multiple filters as an argument. You can apply the different filters that you want in the 2nd, 3rd... argument.

[Ustinovdl]

I mean is there any “selected filters by user” function in dax?
Can I use thos filter with allexcept?

[v-chuncz-msft]

@Ustinovdl,

You may try to use ALLSELECTED Function.

[vega]

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.