topic Re: How to sum rows based on values starting with 2 different numbers in DAX Commands and Tips

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

NPatel12498 — Mon, 01 Jul 2024 19:21:46 GMT

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") )

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

VN999 — Mon, 01 Jul 2024 21:52:55 GMT

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

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

NPatel12498 — Mon, 01 Jul 2024 22:03:18 GMT

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.

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

VN999 — Mon, 01 Jul 2024 22:08:49 GMT

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]
)

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

NPatel12498 — Mon, 01 Jul 2024 22:29:10 GMT

That worked thanks so much!