Logical Conditions

[Anonymous]

Hi, i need some logical conditions, but i don't know hot to make it (syntax).

I need > IF (Dados[NOM_ABERV]) = "304" and (Dados[COD_EQPMT]) ="AOD" and RELATED(Consulta1[COD_TIPO_PRCES])=" F-F " and RELATED(Consulta1[C]) <4 OR  >7 ;  "NOT"; "YES";)

 IF (Dados[NOM_ABERV]) = "304" and (Dados[COD_EQPMT]) ="AOD" and RELATED(Consulta1[COD_TIPO_PRCES])=" F-P " and RELATED(Consulta1[C]) <3,5 OR  >7 ;  "NOT"; "YES";)

 IF (Dados[NOM_ABERV]) = "304" and (Dados[COD_EQPMT]) ="AOD" and RELATED(Consulta1[COD_TIPO_PRCES])=" F-F " and RELATED(Consulta1[C]) <3,5 OR  >7 ;  "NOT"; "YES";)

 IF (Dados[NOM_ABERV]) = "304" and (Dados[COD_EQPMT]) ="AOD" and RELATED(Consulta1[COD_TIPO_PRCES])=" F-P " and RELATED(Consulta1[C]) <10 OR  >99 ;  "NOT"; "YES";)

And I need to count how many results like "NOT"

I have more (Dados[NOM_ABREV]) not just "304" 

 (I'm Brazillian)

[v-jiascu-msft]

Hi @Anonymous,

Try to add the formula below as a calculated column then it's easy to count the result.  Seems the condition 1 and 3, 2 and 4 can be integrated as one. Please check out.

Column =
VAR COD_TIPO_PRCES =
    RELATED ( Consulta1[COD_TIPO_PRCES] )
VAR c =
    RELATED ( Consulta1[C] )
RETURN
    IF (
        Dados[NOM_ABERV] = "304"
            && Dados[COD_EQPMT] = "AOD",
        SWITCH (
            TRUE (),
            COD_TIPO_PRCES = "F-F"
                && ( c < 4
                || c > 7 ), "not",
            COD_TIPO_PRCES = "F-P"
                && ( c < 3.5
                || c > 7 ), "not",
            COD_TIPO_PRCES = "F-F"
                && ( c < 3.5
                || c > 7 ), "not",
            COD_TIPO_PRCES = "F-P"
                && ( c < 10
                || c > 99 ), "not",
            "yes"
        ),
        BLANK ()
    )

Best Regards,

Dale

[Anonymous]

Hi @v-jiascu-msft 

How would the formula convert so? DAX comparison operations are not supported for comparison of text values. Use a VALUE or FORMAT function to convert one of the values.

Thanks !

[v-jiascu-msft]

Hi @Anonymous,

Please adjust these comparison values to your data types. Take the following comments as an example.

Dados[NOM_ABERV] = "304" // if the type of Dados[NOM_ABERV] is TEXT.
Dados[NOM_ABERV] = 304   // if the type of Dados[NOM_ABERV] is Number type.

 If the issue persists, please provide a sample file. Please mask the confidential parts first.

Best Regards,

Dale

[Anonymous]

@v-jiascu-msft Hi,

This error has been corrected, but the return BLANK column and only the last two rows have (C <3.5 OR C> 7) should return "NOT" and the others as they should return "YES".

If you need I can send you a copy of my project.

Thanks so much !

[v-jiascu-msft]

Hi @Anonymous,

Please share the file. That would be the fast way to solve this issue. 

If you can make it public, please paste the download link here.

If you can't, please send me a private message through Message.

Anyway, please mask or delete the confidential parts.

Best Regards,

Dale

[Anonymous]

@v-jiascu-msft  Thanks for your help !!!

https://drive.google.com/open?id=1dMBxXUng3IgM6YRIw3nRxXBgUpi89ShO

[v-jiascu-msft]

Hi @Anonymous,

This link needs permission. I have clicked Request. Please kindly approve. It's dalet****@gmail.com.

Best Regards,

Dale

[v-jiascu-msft]

Hi @Anonymous,

There aren't any "AOD" in column Dados[COD_EQPMT]. That's why it's empty. You can see the result in the Data tab. 

Please add more details or delete this condition.

Best Regards,

Dale

[Anonymous]

Have in (Consulta2[COD_EQPMT_PRODC]) but Dados RELATED with Consulta1 . And Consulta1 RELATED with Consulta2 .

Consulta2 not RELATED with Dados.

[v-jiascu-msft · Accepted solution]

Hi @Anonymous,

Try this formula, please.

Column 1 = 
VAR COD_TIPO_PRCES =
    RELATED ( Consulta1[COD_TIPO_PRCES] )
VAR c =
    RELATED ( Consulta1[C] )
RETURN
    IF (
        Dados[NOM_ABREV] = "304"
            && CALCULATE(min('Consulta2'[COD_EQPMT_PRODC])) = "AOD" ,
        SWITCH (
            TRUE (),
            COD_TIPO_PRCES = "F-F"
                && ( c < 3.5
                || c > 7 ), "not",
            COD_TIPO_PRCES = "F-P"
                && ( c < 4
                || c > 7 ), "not",
           "yes"
        ),
        BLANK()
    )

Best Regards,

Dale

[Anonymous]

It's working, thanks.

You helped me a lot.

But as I do add more   Dados[NOM_ABREV] = "305"  Dados[NOM_ABREV] = "306" Dados[NOM_ABREV] = "307" up to 320.

And each "304" "305" "306" "307" has different specifications

[Anonymous]

I got it