Forum Discussion

freevission2019's avatar
freevission2019
Icon for Helper I rankHelper I
5 years ago

Difference , the % of difference and average

Hi,

I am under intermidiate user of Power Bi and I need your help.

 

the file that I work on is for POs; so the original table named " POs".

I have three columns:

1- Quantity ordered.

2- PO Value in Local Currency ( for all quantities ) 

3- Price in Purchase Requisition ( the price for 1 quantity)

the benefitiary initiates PR and puts estimation price, then after bidding, the PO is issued. I calculated in excel the following:

  •   PRICE ESTIMATION ACCURACY = 3-2/1
  • PRICE ESTIMATION ACCURACY %= PRICE ESTIMATION ACCURACY/ Price in Purchase Requisition
  • The average of PRICE ESTIMATION ACCURACY %

 

How can I do the same in Power Bi using Measures, not created Columns, if possible.

 

Thanks.

 

 

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi freevission2019 

    Please correct me if I wrongly understood your question.

    I get the results you need by measures . Refer to the screenshot below .

     

    PRICE ESTIMATION ACCURACY = CALCULATE(SUM('Table'[Price in Purchase Requisition]))-CALCULATE(SUM('Table'[PO Value in Local Currency])/SUM('Table'[Quantity]))

    PRICE ESTIMATION ACCURACY % = CALCULATE('Table'[PRICE ESTIMATION ACCURACY])/CALCULATE(SUM('Table'[Price in Purchase Requisition]))

    But I don't quite understand you said The average of PRICE ESTIMATION ACCURACY % . Can you provide the value of this field ?

     

    Best Regards

    Community Support Team _ Ailsa Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.