Forum Discussion
Measure that divides two filtered columns
Hello all,
I'm running into an issue where my calculated values are not showing the value I want. See table below for an example of a Project with 3 Work Orders. Each WO has a set number of locations to be completed.
| Project | Work Type | Work Order | Completed | Not Started | In Progress | Total Construction Locations |
| Western 25 | GR OH | 123456 | 83 | 0 | 0 | 83 |
| Western 25 | GA Feeder | 234567 | 0 | 8 | 0 | 8 |
| Western 25 | GA Lateral | 345678 | 0 | 34 | 0 | 34 |
I'm trying to look at the Project as a whole and find the % of completed locations. I would like for it to calculate 83 Completed/125 Total Locations = .664 or 66.4%. However, when I created a column using the formula below, it just gave me 3 rows of 25.04%, which summed to 75.1% (below).
% of Completed = sum('S123 WOs'[Completed Locations by WO])/sum('S123 WOs'[Total Construction Locations])
Can someone help me write the correct formula for a measure to give me 83/125 = .66.4% instead of 75.1%? Keep in mind that the table also contains other Projects, though I listed just one example. Thanks.
Robyn
Anonymous Missed a paren
% of Completed = sum('S123 WOs'[Completed Locations by WO])/CALCULATE(sum('S123 WOs'[Total Construction Locations]),ALL('S123 WOs'[Total Construction Locations]))
4 Replies
- Greg_Deckler
Community Champion
Anonymous
I think:
% of Completed = sum('S123 WOs'[Completed Locations by WO])/CALCULATE(sum('S123 WOs'[Total Construction Locations],ALL('S123 WOs'[Total Construction Locations]))Hi Greg_Deckler ,
I am getting an error for "Too many arguments were passed to the SUM function. The maximum argument count for the function is 1."
☹️
Robyn
- Greg_Deckler
Anonymous Missed a paren
% of Completed = sum('S123 WOs'[Completed Locations by WO])/CALCULATE(sum('S123 WOs'[Total Construction Locations]),ALL('S123 WOs'[Total Construction Locations]))