Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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])
Solved! Go to Solution.
@joshua1990 , Try like
SUMX (values(Attribute List[Article]), MIN ([Sales], [Budget])
@joshua1990 , Try like
SUMX (values(Attribute List[Article]), MIN ([Sales], [Budget])
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
51 | |
46 | |
39 | |
19 | |
19 |