cancel
Showing results for
Did you mean:

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Helper IV

## How to calculate percentage?

Hello ,

I have the below table, Offers, Accepted and Rejected are count from a field

 Date Initiated Candidate Name Accepted / Declined Project / Office Division Location Hiring Source Recruiter Accepted / Declined Date Position 44200 Rami Bashir Accepted Crown Tower HR Qatar Website Tomy 44206 Senior Resident Engineer 44200 Eswara Accepted bridge Finance Abu Dhabi LinkedIn Ralf 44201 Planning Engineer 44200 Owhigho Accepted bridge IT Qatar Gulf Talent Mathew 44200 Safety Officer 44201 Udovicic Accepted bridge Sales Dubai Employee Referral Gordon 44230 Senior Interior Designer

offers is count and others are messures created with dax function

I would like to add a coulmn named conversion percentage to calculate the persentage of acceptance how do i do this?

4 REPLIES 4
Community Support

Hi, @kannanAhammed ;

Is your problem solved?? If so, Would you mind accept the helpful replies as solutions? Then we are able to close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Community Support

Hi, @kannanAhammed ;

``````percent =
VAR _offers =
CALCULATE ( COUNTROWS ( 'Table' ), ALLEXCEPT ( 'Table', 'Table'[offers] ) )
RETURN
DIVIDE ( [Accepeted], _offers + [Accepeted] + [Rejected] + [Other] )
``````

If not, can you share more details and your  detailed logic and desired output ?

The most important parts are:
1. Sample data as text or screenshots.
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Super User

@kannanAhammed , Not very clear, but a measure like

Divide(count(Table[offers]), count(Table[offers]) +[Accepeted]+[Rejected]+[Other])

Assuming last three are measures

or

Can you share sample data and sample output in table format?

Helper IV

Hello Amit,

for some reason I am getting the 1 as the output from the mesure created as you advised.

I have updated the table as advised, Please see the original post.

Announcements

#### Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

#### Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

#### The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors