Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago
Solved

Split an IF

hello I have the following code dax that returns me a number of those that are blank Orders that did not enter = if(Difference[Orders Exist in Orcon] = BLANK(), 1, 0) this when counting it...
  • v-angzheng-msft's avatar
    v-angzheng-msft
    4 years ago

    Hi, Syndicate_Admin 

     

    Try this:

    % =
DIVIDE (
    SUM ( Difference[Orders that did not enter] ),
    COUNT ( 'Difference'[Nro_de_Negocio] )
)

    Because your [Nro_de_Negocio] column is a numeric type instead of a text type, when you sum the column, the result is much greater than 225, so you get a result close to 0.

     

     

    Best Regards,
    Community Support Team _ Zeon Zheng


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago

use this formula

% =
DIVIDE(
SUM(Difference[Orders that did not enter]),
SUM('Difference'[Nro_de_Negocio])
)
BEAT_CRETAMAL_0-1638137993943.png

me da 0

BEAT_CRETAMAL_1-1638138105375.png

  • v-angzheng-msft's avatar
    v-angzheng-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi, Syndicate_Admin 

     

    Try this:

    % =
DIVIDE (
    SUM ( Difference[Orders that did not enter] ),
    COUNT ( 'Difference'[Nro_de_Negocio] )
)

    Because your [Nro_de_Negocio] column is a numeric type instead of a text type, when you sum the column, the result is much greater than 225, so you get a result close to 0.

     

     

    Best Regards,
    Community Support Team _ Zeon Zheng


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.