Sum up on row level for Total Number

[joshua1990]

I have a sales table and a budget table.

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.

Sales

Date	Article	Sales
01.01.2021	A	500
01.01.2021	B	550

Budget

Article	Budget
A	500
C	600

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])

[amitchandak · Accepted solution]

@joshua1990 , Try like

SUMX (values(Attribute List[Article]), MIN ([Sales], [Budget])