How to create a measure to calculate something like this (A-B)/A in each row

[freevission2019]

Hi,

good day.

I have a table called POs, and there are two columns; one for PR price and another for PO price and I want to get the following:

1-( PR -PO )/PR

2- The Average of that.

3- how many row was "the result in 1" greater than 20%

can you help.

Best Regards.

[freevission2019]

Thank you very much Jihwan. 

perfect😊 👌

[Jihwan_Kim · Accepted solution]

Hi, @freevission2019 

Please correct me if I wrongly understood your question.

If you are looking for something like below,

please check the below link, which is the sample pbix file.

Otherwise, if it is OK with you, please share your sample data file, then I can look into it to come up with more accurate measures.

average of that =

AVERAGEX( 'Table', DIVIDE('Table'[PR Price] - 'Table'[PO Price], 'Table'[PR Price]))

countrows greater than 20% =

COUNTROWS( FILTER('Table', [average of that] >0.2))

https://www.dropbox.com/s/2f7lofgletydns5/freevission2019%202021%200327.pbix?dl=0 

Jihwan Kim

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