Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

DAX Formula Error last step

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..

 

  • 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

3 Replies

  • 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's avatar
      Anonymous
      Not applicable

      No Filter

      • amitchandak's avatar
        amitchandak
        Super User

        Anonymous , can you explain what you are trying to get