The sales table shows me the sales for each article and the budget table shows me the budget for each article, if available. There is no budget for every article. Both tables are linked to an attribute list that contains all articles.
Now, I would like to SUM the minimum Budget and Sum for each article.
For that, I use a simple MIN ([Sales], [Budget]).
Now, if I use a matrix to show the result for each article, then it works.
But if a drill the data up to department or country level, then I get a false result.
Do I need an iterative function?
This is not working: SUMX (Attribute List, MIN ([Sales], [Budget])