cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
joshua1990
Post Prodigy
Post Prodigy

Sum up on row level for Total Number

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

DateArticleSales
01.01.2021A500
01.01.2021B550

 

Budget

ArticleBudget
A500
C600

 

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

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@joshua1990 , Try like

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

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin
Want To Learn Power BI
Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@joshua1990 , Try like

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

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin
Want To Learn Power BI
Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!

View solution in original post

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors