Dax measure

[pro_x]

Hi 

I have one column, only one column that has rejected and successful. Rejected is represented by 0 and successful is represented by 1. How can I calculate the percentage difference for rejected and successful separately?

[Anonymous]

@pro_x Can you share some sample data and expected out? That way people here can help you quickly.

Thanks

[pro_x]

This is the data I have, rejected is represented by 0 and successful is represented by 1.

[amitchandak]

@pro_x , two measures likes

Mark all them as % column

successful =divide(calculate(countrows(Table),Table[col]=1),countrows(Table))

Rejected  =divide(calculate(countrows(Table),Table[col]=0),countrows(Table))

percentage difference = [successful] -[Rejected]

[pro_x]

Hi

Thank you,

How would i calculate the percentage change for Rejected?

[harshnathani]

Hi @pro_x ,

%Change will require your earlier period rejected Values.

You need to share sample data and expected output to get the correct solution.

Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[pro_x]

Hi this is my sample data. Rejected is represented by 0and successful is represented by 1.

 

[harshnathani]

Hi @pro_x ,

What is the final output you want from the sample column shared.

Regards,

Harsh Nathani

[pro_x]

Hi @harshnathani 

I want the percentage change

[harshnathani]

Hi @pro_x 

% change is difference of old percentage vs new percenatage. Like Sales Last year vs This year

You need to share a good sample of data with the earlier dates,

One column cannot detemine %change when there is no context to that column.

Do you want difference between successful and reject.??

Regards,

Harsh Nathani

[pro_x]

Hi @harshnathani 

Yes, i want like sales last year vs this year.

e.g. rejected last year vs this year 

I only have that column with another column for date 

[pro_x]

Hi @harshnathani 

Yes you're right, so how would i go about extracting the earlier period for rejected. I only have one column that has rejected and successful. Should i create a conditional column to extract rejected. How would i extract the earlier period and do a %change?

[mhossain]

Hi @pro_x 

Your problem seems interesting, what do you mean % changes for successful and rejected seprately, changes on what basis?

[pro_x]

Hi @mhossain 

%change on earlier period for rejected and successful. I want a measure that shows the %change for rejected over a certain period and a measure that shows % change for successful over a certain period. I have a column that has rejected and successful in one column.