Forum Discussion
EvanBeiser
10 years agoFrequent Visitor
DAX : Filtering for multiple accounts
Hello all, I am having some trouble with DAX when I attempt to filter for multiple accounts. Currently what I am using is, Direct Labor = SUMX(FILTER('ACCOUNT_BALANCE',' ACCOUNT_BALANCE'[ACCO...
wonga
10 years agoContinued Contributor
Couldn't you just use an attribute slicer custom visual to sort through multiple account numbers? (This has a search bar, but it isn't fully developed if you have a long list of values; need to scroll through the entire list first before you can search the entire thing).
Also, the standard summation of the values in [AMOUNT] should do the job for you instead of going through the trouble of making DAX expressions for each account number. I might be misunderstanding your problem, so if you could provide a sample dataset and the expected value for "Direct Labor", that would probably clear a few things up. Thanks.