Forum Discussion
Solved
DAX Sum column based on condition in other columns in same table
Hello, I have a table with a column of UserIDs that only appear once each of which has a ManagerID as well as a value of Total # of Assets. I want to for each UserID add their Total # of As...
v-danhe-msft I found a DAX function to solve my issue
I used = CALCULATE(SUM('3'[# of Assets(total)]),FILTER('3', [Manager ID] = EARLIER('3'[UserID])))
Thanks for the help anyways,
CC
v-danhe-msft I found a DAX function to solve my issue
I used = CALCULATE(SUM('3'[# of Assets(total)]),FILTER('3', [Manager ID] = EARLIER('3'[UserID])))
Thanks for the help anyways,
CC
If I may ask, what does the 3 represent in your formula?