Forum Discussion
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...
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 actually it works at total level and when I want to filter. But if I add a filter like plant into a table it shows total and won't break it down unless i filter. but once i filter on lets say C01 the numbers appear?
once i filter numbers break down properly. I think i solved this by removing the ALLSELECTED
Cool, I thought you wanted total for the conditions plus anything that is selected through slicers.
AntrikshSharma Yes, you are right initially I did but then realized I need to see more data. thanks!