cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Custom Column - Sum Quantity based on texts in another column

I have data coming in from assemble. This data has sqft of walls. I then have status of walls i.e. frame, hung and finsihed. I am trying to create a custom column that sums the sqft if the status equals a text value. The wall can have a status of hung but if it is hung it has to be framed so the custom column formula I am looking for would sum the quantity if the status = framed or hung or finished. I have made this work as a meassurment but I want it to work as a column so I have more flexability in visualizations.

 
SUMX(FILTER('Grid Data','Grid Data'[Drywall Status]="Framed"),'Grid Data'[Takeoff Quantity])
1 ACCEPTED SOLUTION
Anonymous
Not applicable

so I have now made it this far:

if([Drywall Status]="Framed")or([Drywall Status]="1 Side hung")or([Drywall Status]="1 side hung – 1 side top out finished")or([Drywall Status]="1 side hung & finished")or([Drywall Status]="1 side top out")or([Drywall Status]="1-Side top out & Finished")or([Drywall Status]="2 sides hung")or([Drywall Status]="2 sides hung & finished")or([Drywall Status]="2 sides hung, 1 side finished")then([Takeoff Quantity])else 0

 

Next I need it to sum

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

so I have now made it this far:

if([Drywall Status]="Framed")or([Drywall Status]="1 Side hung")or([Drywall Status]="1 side hung – 1 side top out finished")or([Drywall Status]="1 side hung & finished")or([Drywall Status]="1 side top out")or([Drywall Status]="1-Side top out & Finished")or([Drywall Status]="2 sides hung")or([Drywall Status]="2 sides hung & finished")or([Drywall Status]="2 sides hung, 1 side finished")then([Takeoff Quantity])else 0

 

Next I need it to sum

Anonymous
Not applicable

so I just needed to change the data type from any to number. 

 

All is working as I hoped. 

Helpful resources

Announcements
Exciting changes

Power BI Community Changes

Check out the changes to the Power BI Community announced at Build.

May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Kudo Data Story carousel

Data Stories Gallery

Visit our Data Stories Gallery and give kudos to your favorite Data Stories.

Top Solution Authors