DAX Formula Error last step

[Anonymous]

Hi Experts

I am getting an error on my measure on the last row... cannot see the mistake

Rows with Material =
CALCULATE(
    COUNTROWS( 'App Forms' ),
    LEFT( 'App Forms'[Impact], 8 ) = "Material" &&
    COUNTROWS( 'App Forms' ),
    LEFT( 'App Forms'[Reg], 8 ) = "Material" &&
    COUNTROWS( 'App Forms' ),
    LEFT( 'App Forms'[Media], 8 ) = "Material" &&
    COUNTROWS( 'App Forms' ),
    LEFT( 'App Forms'[Financial], 8 ) = "Material" &&
    COUNTROWS( 'App Forms' ),
    LEFT( 'App Forms'[Businesss], 8 ) = "Material"  &&
    COUNTROWS( 'App Forms' ),
    LEFT( 'App Forms'[Incident], 8 ) = "Material"  &&
    COUNTROWS( 'App Forms' ),
    LEFT( 'App Forms'[External], 8 ) = "Material")

the error is here after the last comma 
,LEFT( 'App Forms'[External], 8 ) = "Material")

The Synatc for "," is incorrect....

I have tried using but && and || signs..

[amitchandak · Accepted solution]

@Anonymous , what countrow doing in between at filter location

Try like

Rows with Material =
CALCULATE(
COUNTROWS( 'App Forms' ),
LEFT( 'App Forms'[Impact], 8 ) = "Material" &&
LEFT( 'App Forms'[Reg], 8 ) = "Material" &&
LEFT( 'App Forms'[Media], 8 ) = "Material" &&
LEFT( 'App Forms'[Financial], 8 ) = "Material" &&
LEFT( 'App Forms'[Businesss], 8 ) = "Material" &&
LEFT( 'App Forms'[Incident], 8 ) = "Material" &&
LEFT( 'App Forms'[External], 8 ) = "Material")

you can replace && with or || if needed

[Anonymous]

No Filter

[amitchandak]

@Anonymous , can you explain what you are trying to get