How to sum rows based on values starting with 2 different numbers

[NPatel12498]

Hi,

I am trying to do a calculation within a column that takes the sum of all the raw costs where the Org name starts with either a "1" or a "3" and the Cost Category = Regular Labor

This is the formula that I have but not sure if it is correct:

S&T Labor = 
CALCULATE(
	SUM('Raw Costs'[ACCT_RAW_COST]),
	'Raw Costs'[ICE_MODEL_COST_CATEGORY]= "Regular Labor" && OR(LEFT('Raw Costs'[ORG_NAME],1) = "1", LEFT('Raw Costs'[ORG_NAME],1)="3")
)

[NPatel12498]

That worked thanks so much!

[VN999]

Please provide more deatils with some example data to understand requirement correctly?

[NPatel12498]

HI, I need to take the sum of all of the rows where the Org Name starts with "1" or "3" and has a Cost Category = "Regular Labor".. in the screenshot below, it would be $6,327,373 + $264,953 = $6,592,326.

[VN999 · Accepted solution]

Try to create DAX Measure and check :

TotalRegularLabor :=
SUMX (
FILTER (
YourTable,
(LEFT(YourTable[Org Name], 1) = "1" || LEFT(YourTable[Org Name], 1) = "3") &&
YourTable[Cost Category] = "Regular Labor"
),
YourTable[Amount]
)