I've got a table like this
My purpose is to create a column with the total sum for each component and for each MoID of the quantity needed for production:
What is the correct DAX formula to use? Thank you.
Go to Solution.
You can also try the column, like this:
Column = SUMX(FILTER('Table',[MoID]=EARLIER('Table'[MoID])&&[Compoent]=EARLIER('Table'[Compoent])),[Qty])
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
View solution in original post
TotalComponentQTY = CALCULATE(SUM(Table[Qty]), ALLEXCEPT(Table, Table[MoID], Table[Component]))
Proud to be a Super User!Paul on Linkedin.
Click here to read more about the December 2021 Updates!
Mark your calendars and join us for our next Power BI Dev Camp!
Learn how to create your own user groups today!