Forum Discussion

k3rz0rg's avatar
k3rz0rg
Advocate 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.
Ashish_Mathur's avatar
Ashish_Mathur
Super User
3 years ago

Hi,

Does this measure work?

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