Forum Discussion
calculate defect rate with DAX
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?
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 namesMeasure = DIVIDE(SUM(Table1[Rated Complaint]),SUM(Table2[Qty in Un. of Entry]))
3 Replies
- Stachu
Community Champion
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- Stachu
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 namesMeasure = DIVIDE(SUM(Table1[Rated Complaint]),SUM(Table2[Qty in Un. of Entry]))