Probablity measure

[Arnechos]

Basically I have to make a probablility of malfuction of vehice.

malfunction/amount of cars with certain mileage * 100

I came up with this formula and in DAX I have a problem with certain mileage

(CALCULATE(COUNT('table'[STATUS]);FILTER('table';SEARCH("malfunction";'table'[STATUS];1;0))))/COUNT(vehicles[License_plate])

I have no idea how to make it count probablility based on sum of vehicle with certain amount of mileage 

[Greg_Deckler]

Can you provide some example/sample data and what you expect as output? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490