Forum Discussion
Solved
How to sum rows based on values starting with 2 different numbers
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 ...
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]
)
That worked thanks so much!