Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
Syndicate_Admin
Administrator
Administrator

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

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.

View solution in original post

3 REPLIES 3
Syndicate_Admin
Administrator
Administrator

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

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.

Gabriel_Walkman
Continued Contributor
Continued Contributor

What is the error?

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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