Forum Discussion
Probablity measure
Basically I have to make a probablility of malfuction of vehice.
malfunction/amount of cars with certain mileage * 100I 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
1 Reply
- Greg_Deckler
Community Champion
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
