Forum Discussion

ericbi's avatar
ericbi
Frequent Visitor
8 years ago
Solved

How to calculate percentage in row

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 calcul...
Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    8 years ago

    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.

     

     

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago
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

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    5 years ago

    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's avatar
      Anonymous
      Not applicable
      5 years ago

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

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Icon for Super User rankSuper User
        5 years ago

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