Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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.
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
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.
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.
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 |
Hi,
Assuming you have created the total measure, try this measure
=[Total]/46
Express this as a %.
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.
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.
Hi Phil,
it's working!
thank you so much!