cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.