Forum Discussion

Bryanna's avatar
Bryanna
Icon for Helper II rankHelper II
3 years ago

Sum Total from different column result

Hi,   I am trying to create a measure that would sum the totals from each of these so i can add it in below and do additional measures off of this. When I try to just sum, it still breaks it out un...
Bryanna's avatar
Bryanna
Icon for Helper II rankHelper II
3 years ago

Here you go. I know I can just do the sum on the column subtotals but i need to use the qty in another calculation as well so really need it in a measure.

 
PO or Order NumberPart Number
1234567891205
784553515472
658745953485
Total Qty2,162

 

AnthonyGenovese's avatar
AnthonyGenovese
Icon for Resolver III rankResolver III
3 years ago

If you are trying to get the total quanity, it will look something like this.

 

Calculate(Sum(PartNumber), All(PO or Order Number))

 

If this post was helpful, please kudos or accept the answer as a solution.
~ Anthony Genovese
Need more PBI help? PM me for affordable, dedicated training or consultant recomendations!