Inserting LEFT into DAX functions for Measure

[Sphinx404]

I am trying to pick out a certain word in a measure I am trying to create in Power Pivot and with my unfamiliarity with DAX functions, it's throwing me off.

Hoping there are some experts on here that can help.

Below is my first attempt to find the first 8 characters in the column I am looking at, the first 8 characters being "Assembly"

=CALCULATE(COUNTROWS(defects),Defects(Defects[Cause Area Description],LEFT(8)="Assembly"))

This comes up with an error. Any ideas?

 

[steve the fish]

Cant say i know too much about DAX formulas but id imagine you need the column in there

 

[sheetspread]

Something like:

=sumx(values(Table2[Cause Area Description]),if(left([Cause Area Description],8)="Assembly",Table2[Count of Cause Area Description],0))

 

[Sphinx404]

Nice. Thank you!

Can you answer another?

The first part of my function in GREEN works great. However, when I try to add in the other part in RED, then it goes to hell.

ideas?

[B][COLOR=#008000]=CALCULATE(COUNTROWS(Defects),Defects[Cause Area Description]=" Assembly - Auger Sub"[/COLOR][/B],[B][COLOR=#ff0000]COUNTROWS(Defects),Defects[Found Area ID]="400")[/COLOR][/B]

 

[sheetspread]

This?

=CALCULATE(COUNTROWS(Table2), FILTER (Table2,Table2[Cause Area Description] = "Assembly - Auger Sub" && Table2[Found Area ID] = 400))