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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ericbi
Frequent Visitor

How to calculate percentage in row

Hi, 

 

I have a table like this. Status Y means won the quotation. 

 

1.JPG

 

I would like to have a report showing the % of won for each person. 

eg. 

2.JPG
I've tried some measures to calculate but can't give me the correct result. 

 

thank you. 

1 ACCEPTED SOLUTION
Phil_Seamark
Employee
Employee

Hi @ericbi

 

Please add the following three calculated measures to your model

 

Total Win = COUNTROWS(FILTER('Table1','Table1'[Status]="Y"))
Count of Quote No. = COUNTROWS('Table1')
% of Win = DIVIDE([Total Win],[Count of Quote No.])

Format that last measure as a percent and drag all three to a table visual using the Full Name field and it should work.

 

 

percent.png

 


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

View solution in original post

10 REPLIES 10
Anonymous
Not applicable

Sold priceSold costSold Gp
16086892219 
3803617586 
2999018331 
9202063195 
200800162859 
425282122059 
201630134364 

I have to calculate the Percentage in each rows as  based on the formula (As sold price - as sold cost)/as sold price . As I am new to the Power Bi pls let me know how to achieve this

Hi,

Assuming the picture you posted is that of a visual (and not of your source data) and that Sold Price and Sold Cost are measures, write this measure

GP % = divide([Sold Price]-[Sold cost],[Sold price])

Hope this helps.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Anonymous
Not applicable

Actually, it's a column. but I have converted it as a measure. now it's working as expected. Thank You

You are welcome.  If my reply helped, please mark it as Answer.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
deeksha_12
New Member

Hi, 

 

I have tried the same to calculate by creating one index column for a numeric denominator(46) for each row. 

But here i want the total column to display the percentage value by dividing each total with value 46.

Please let me know how can i do it. 

 

 A1B1C1(Total)/46*100
Student 11001323
Student 2123015
Student 3324431

 

Hi,

 

Assuming you have created the total measure, try this measure

 

=[Total]/46

 

Express this as a %.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Phil_Seamark
Employee
Employee

Hi @ericbi

 

Please add the following three calculated measures to your model

 

Total Win = COUNTROWS(FILTER('Table1','Table1'[Status]="Y"))
Count of Quote No. = COUNTROWS('Table1')
% of Win = DIVIDE([Total Win],[Count of Quote No.])

Format that last measure as a percent and drag all three to a table visual using the Full Name field and it should work.

 

 

percent.png

 


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

HI,

And how about if Status has 30 different school names...do I create a measure for Status = 1, Status = 2, Status = 3 etc?

Laurie

 

 

Hi,

 

Share a dataset and show the expected result.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Hi Phil, 

it's working!

thank you so much! 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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