cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

## 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 gives me 45
in the other column I perform a search for one column with another and it returns a number 224
LOOKUPVALUE(INF01_Ordenes_v2_2[North],INF01_Ordenes_v2_2[North],Difference[Nro_de_Negocio])
now I want to make a rate of how much percentage affects from 45 to 224 but I make a division of the 2 columns and does not allow me, how could I do this ?
upshot:
Total | No income| Impact rate %
224 | 45 | 20,08%
Thank you
1 ACCEPTED SOLUTION
Community Support

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.

3 REPLIES 3

use this formula

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

me da 0

Community Support

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.

Continued Contributor

What is the error?

Announcements

#### Fabric certifications survey

Certification feedback opportunity for the community.

#### Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

#### Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors