Divide With 2 filters Measure

[Stuznet]

On an Excel I created a matrix for Late and On-Time is based on Status 2 Column. I want to know how to divide column "=C/D" with a Status text filter "Late" and "On-Time"? Column E is what I'm looking for is the percentage. 

 

I created a measure 

Measure= DIVIDE(SUM(Data[ID]), SUM(Data[Status2]), FILTER(Data,Data[Status2] = "Late" && Data[Status2]="On-Time"))

but I'm getting an error 

Then I tried this formula 

Measure2 = DIVIDE(CALCULATE(SUM(Data[ID]),Data[Status2]="Late"),CALCULATE(SUM(Data[ID]),Data[Status2] = "On-Time"))

I got this error

What am I doing wrong here?

[MFelix · Accepted solution]

Hi @Stuznet,

You second measure is correct however you need to do a count your ID column is type text and you cannot sum text fields.

Measure2 =
DIVIDE (
    CALCULATE ( COUNT ( Data[ID] ), Data[Status2] = "Late" ),
    CALCULATE ( COUNT ( Data[ID] ), Data[Status2] = "On-Time" )
)

Regards,

MFelix

[Stuznet]

Thank you so much it worked I just need to change the whole number to Percentage. 🙂 

[MFelix]

Select the measure and on the modeling tab select the %.

Regards,

MFelix