Difference , the % of difference and average

[freevission2019]

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.

[v-yetao1-msft]

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.