Forum Discussion

powerbihelp87's avatar
powerbihelp87
Helper V
6 years ago
Solved

Help with DAX for SumX and Filter function on multiple columns

I need to calculate the sum of two columns based on filters. I tried:   SUMX(FILTER('Test Table','Test Table'[Code="10023" || 'Test Table'[Code]="10039" && 'Test Table'[Category]="az" && 'Test Tabl...
Need Help
  • AntrikshSharma's avatar
    AntrikshSharma
    6 years ago

    Try this:

    =
SUMX (
    FILTER (
        ALLSELECTED ( 'Test Table' ),
        ( 'Test Table'[Code] = "10023"
            || 'Test Table'[Code] = "10039" )
            && ( 'Test Table'[Category] = "az"
            || 'Test Table'[Category] = "ac" )
    ),
    'Test Table'[ Amount]
)

     

AntrikshSharma's avatar
AntrikshSharma
Community Champion
6 years ago

Cool, I thought you wanted total for the conditions plus anything that is selected through slicers.

powerbihelp87's avatar
powerbihelp87
Helper V
6 years ago

AntrikshSharma  Yes, you are right initially I did but then realized I need to see more data.  thanks!