Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Defect Rate Formula

I am VERY new to PowerBI and have been struggling with calculating a defect rate for weeks. Please help!   I have a table that has R (regular) and W (warranty) orders. I want to divide the InvoiceQ...
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    Anonymous

     

    Hi, are using DAX in Query Editor (This use Power Query Language).

     

    To obtain this you can create a New Measure.

     

    DEFECTRATE =
DIVIDE (
    CALCULATE (
        SUM ( [InvoiceQty] ),
        FILTER ( YOURTABLE, YOURTABLE[OrderType] = "W" )
    ),
    CALCULATE (
        SUM ( [InvoiceQty] ),
        FILTER ( YOURTABLE, YOURTABLE[OrderType] = "R" )
    )
)

    Regards

     

    Victor

    Lima - Peru

Vvelarde's avatar
Vvelarde
Icon for Community Champion rankCommunity Champion
9 years ago

Anonymous

 

Hi, are using DAX in Query Editor (This use Power Query Language).

 

To obtain this you can create a New Measure.

 

DEFECTRATE =
DIVIDE (
    CALCULATE (
        SUM ( [InvoiceQty] ),
        FILTER ( YOURTABLE, YOURTABLE[OrderType] = "W" )
    ),
    CALCULATE (
        SUM ( [InvoiceQty] ),
        FILTER ( YOURTABLE, YOURTABLE[OrderType] = "R" )
    )
)

Regards

 

Victor

Lima - Peru

Anonymous's avatar
Anonymous
Not applicable
9 years ago

So I am taking this formula a few steps further and I am stuck. Below I have added in DefectReason that is not AB Damage, I also need to add in that the DefectReason is not Concealed Damage or Goodwill. I tried with a comma but it does not like it. How can I add more?

 

UnfilterDefectRate = DIVIDE(
CALCULATE(
SUM ( vSalesMaster[WarrDetail.InvoiceQty] ),
FILTER (vSalesMaster,vSalesMaster[OrderType] = "W" &&
vSalesMaster[WarrDetail.DefectReason] <> "AB Damage" )
),
CALCULATE(
SUM ( [InvoiceQty] ),
FILTER (VSalesMaster,vSalesMaster[OrderType] = "R")
)
)