calculate defect rate with DAX

[hongyuliu]

I need to calculate defect rate for every month. I usually divide the number of defect by the number of monthly delivery. Then, what is the DAX expression for this?

[Stachu]

how does your data look like? have a look at this post on how to get answers quickly
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[hongyuliu]

They are in different tables. I need to divide the number of Rated Complaint of January by the number of Qty of January.

[Stachu · Accepted solution]

create a separate table with date to join between the 2 tables, use month from that table

for the measure try this, just adjust the table names

Measure = 
DIVIDE(SUM(Table1[Rated Complaint]),SUM(Table2[Qty in Un. of Entry]))