Count if cell greater than another in same row

[Anonymous]

Seeking Dax Formula to:

1.  Count number of stock lines where "Stock on Hand" is Greater than "Maximum Stock". eg. using below capture four lines indicate the "On Hand" is greater than "Maximum Stock".  Therefore result should be 4 when I create a visual

2. Count Qty where "Stock on Hand" is Greater than "Maximum Stock" value from the above. eg. Item Code 4008151 has Qty 12 "On Hand" therefore Count over "Maximum stock" result should be "7"

3.  Value of Qty where "Stock on Hand" is Greater than the "Maximum Stock" using "Last cost" for the Item Code. 

[m-kats]

Hello @Anonymous 

Maybe you should try the countx and sumx functions like:

1. No of Stock Lines = COUNTX(FILTER('Table', 'Table'[Stock on Hand]>'Table'[Maximum Stock]), 'Table'[Maximum Stock])

2. I cannot find the difference between the 1st and 2nd bullet

3.  Sum of Cost = SUMX(FILTER('Table', 'Table'[Stock on Hand]>'Table'[Maximum Stock]), 'Table'[Last cost])

Hope I helped!