Forum Discussion

k3rz0rg's avatar
k3rz0rg
Icon for Advocate III rankAdvocate III
3 years ago
Solved

Need help with multiple filter values in DAX!

Hi everyone, I've been trying to do the following codes in a DAX formula, however, it is not working as it does via applying the filters on filter pane. I have Stage column with value from A to E an...
Need Help
  • sanc_152's avatar
    sanc_152
    3 years ago

    Hi k3rz0rg 

    try with this one ..

    Measure 3 =
    VAR SUMMRIZE_
           =CALCULATETABLE(
            'DATA',
            not( 'DATA'[Stage] in{ "A", "Other"})
           )

      VAR  Result=

     CALCULATE(
             SUMX(
                 FILTER(SUMMRIZE_,
                                [Field 1]="Spend Management"&&
                                [Type] = "New"&&
                                [Code] <> 1231
                 ),
           [Credit]
                )
     )
    RETURN Result

     

    Note: If this post helps mark this one as accepted.
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

k3rz0rg , try like

 

var _Calc2 = CALCULATE(
SUM('data'[Credit])
Filter( 'data', 'data'[Field 1] = "Spend Management"
&& 'data'[Type] = "New"
&& 'data'[Code] <> "1231" && not( ,'data'[Stage] in{ "A", "Other"})
) )

  • k3rz0rg's avatar
    k3rz0rg
    Icon for Advocate III rankAdvocate III
    3 years ago

    Thank you for the response, unfortunately I've already tried the FILTER() and tried your method as well but it is not considering multiple values inside IN { } , it only filters based on one value (in this case A between A and Other) no matter how many values I put inside the curly braces.