Forum Discussion

Jameswh91's avatar
Jameswh91
Icon for Helper III rankHelper III
4 years ago

Sum with filter

Hi, I'd like help with a filtered calculation. I'm looking to sum the net sales but filtering out the other countries.   Any idea as to the example dax?
DAX
SUM based on some filter
NilR's avatar
NilR
Icon for Post Patron rankPost Patron
4 years ago

Measure Name= 
var _Countires= SelectedValue('table'[countriecolumn])
var _OtherFilterSlicers= SelectedValue('table'[slicer])

Return
Calculated(Sum(Sales),filter('table', [countriescolumn]=_Countires && [othercolumns]=_OtherFilterSlicers)