DAX formula to count rows in one column based on value of another column

[maven23]

Hi!

I need help on this please since I've tried all other formulas I've seen in forums but to no avail. I have raw data with values and want to count the total passing and total number of samples based on criteria column (whether they are equal or less than the criteria). Each parameter also has a weight and compliance ratio is based on the number of passing samples multiplied by the criteria weight. The total number of samples is easy but count of pass and compliance ratio is quite challenging. Below is sample data and desired output. Your help is greatly appreciated. Thanks in advance.

P.S. I corrected the file, since what was uploaded earlier is incorrect. Thanks. 

[amitchandak]

@maven23 , Try a measure like . assume you have two measures

[Pass sample],[total Sample]

Max(Table[Creteria Percent]) * divide([Pass sample],[total Sample]) 

[maven23]

Corrected the file since what I uploaded earlier is incorrect. I just made up some fictitious data and since I'm in a hurry to post, I just drag the cursor without checking the criteria and weight. My bad. 😅