I have a table that contains all the motorcycles (by bike number) and lists the daily defects (if any) based on the system of each motorcycle.
I made two charts: one for the total fault of each bike, and the other for the system fault of all the motorcycles.
Similarly, I've made another table to track the motorcycles testing mileage monthly that each of the motorcycles has covered so far. Zero mileage indicated that the motorcycle was under repaired in the workshop of that month.
I'd like to ask for assistance in writing a DAX or making changes to the charts so that they are tracked by:-
1) Divide the total defect by the mileage for each motorcycle.
2) The system's fault divided by the total mileage of all involved motorcycles?
I made two charts: one for the total fault of each bike, and the other for the system fault of all the motorcycles.
Similarly, I've made another table to track the motorcycles testing mileage monthly that each of the motorcycles has covered so far. Zero mileage indicated that the motorcycle was under repaired in the workshop of that month.
I'd like to ask for assistance in writing a DAX or making changes to the charts so that they are tracked by:-
1) Divide the total defect by the mileage for each motorcycle.
2) The system's fault divided by the total mileage of all involved motorcycles?
