topic Re: How to create a sumx with 2 filter conditions in DAX Commands and Tips

How to create a sumx with 2 filter conditions

JL0101 — Tue, 25 Jun 2024 12:25:20 GMT

I have the following code

PivCouplers-Male =

SUMX(
FILTER(
PivCouplers,
CONTAINSSTRING(('PivCouplers'[shape_code]),"m")),[SumOfShapeCode])

How do I add an aditional Filter below CONTAINSSTRING to include something along the lines of AND take the latest model, i.e. what is the syntax for 2 filters or more on the SUMX ?

Thanks

Re: How to create a sumx with 2 filter conditions

barritown — Tue, 25 Jun 2024 20:43:59 GMT

Hi JL0101,

I guess you should try using "&&" as AND, like: SUMX ( FILTER ( Table, CONDITION_1 && CONDITION_2 ), [Measure or Column] ).

Best Regards,

Alexander

My YouTube vlog in English

My YouTube vlog in Russian

Re: How to create a sumx with 2 filter conditions

JL0101 — Wed, 26 Jun 2024 09:54:29 GMT

The syntax for 'SUMX' is incorrect. (DAX(VAR MaxRevision = MAX('PivCouplers'[A-schedule_revision_numbers])SUMX( FILTER( PivCouplers, CONTAINSSTRING(('PivCouplers'[shape_code]),"m") && 'PivCouplers'[A-schedule_revision_numbers] = MaxRevision ),[SumOfShapeCode] ))).

Re: How to create a sumx with 2 filter conditions

Anonymous — Thu, 27 Jun 2024 05:24:33 GMT

Hi JL0101

Return is missing from your formula, so please try this:

VAR MaxRevision = MAX ( 'PivCouplers'[A-schedule_revision_numbers] ) RETURN SUMX ( FILTER ( PivCouplers, CONTAINSSTRING ( ( 'PivCouplers'[shape_code] ), "m" ) && 'PivCouplers'[A-schedule_revision_numbers] = MaxRevision ), [SumOfShapeCode] )

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.