New to DAX - Trying to combine filter/count/if

[Anonymous]

Hello,

Thanks for taking the time to read my post. I am new to DAX and have been trying to use sums/filters/ifs to identify jobs that procurement need to focus on. I have added a snip of some example data (The real data has hundreds of jobs) and an example of what I am trying to do. The first table is an example of the data, I am then trying to filter to each job, sum the required column, and then sum the quantity column (But sum only to the max of the required column). Then I would add a readiness column (Quantity Sum/Required Sum) as a percentage and sort by lowest. If you could please have a look and let me know how to do this, or where I can look to get some help I would greatly appreciate it.

[Anonymous]

Hi, 

I created an example document on how you can achieve this. 

https://1drv.ms/u/s!AnIEh6WhI4Jog5Vz1k9Ap5T1xyjDag?e=ZL0jZj 

Essentially, I added a column =

Quantity2 = IF(ExampleDate[Quantity]>ExampleDate[Required],ExampleDate[Required],ExampleDate[Quantity]) 

Then I created a measure = 

Readiness = SUM(ExampleDate[Quantity2])/SUM(ExampleDate[Required])