How to calculate percentage in row

[ericbi]

Hi, 

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

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

eg. 

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

thank you. 

[Anonymous]

Sold price	Sold cost	Sold Gp
160868	92219
38036	17586
29990	18331
92020	63195
200800	162859
425282	122059
201630	134364

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

[Ashish_Mathur]

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.

[Anonymous]

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

[Ashish_Mathur]

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

[deeksha_12]

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. 

	A1	B1	C1	(Total)/46*100
Student 1	10	0	13	23
Student 2	12	3	0	15
Student 3	3	24	4	31

[Ashish_Mathur]

Hi,

Assuming you have created the total measure, try this measure

=[Total]/46

Express this as a %.

[Phil_Seamark · Accepted solution]

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.

[Hillsla]

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

[Ashish_Mathur]

Hi,

Share a dataset and show the expected result.

[ericbi]

Hi Phil, 

it's working!

thank you so much!