Calculate percentage on subgroup for string

[Anonymous]

Hi,

I want to calculate the percentage of each category (Late or OnSchedule) under each carrier. 

Month	Week	Carrier	LateOnSched
1	1	UPS	OnSchedule
1	2	UPS	OnSchedule
1	3	UPS	OnSchedule
1	4	UPS	Late
2	5	UPS	OnSchedule
2	6	SEFL	OnSchedule
2	7	SEFL	OnSchedule
2	8	SEFL	OnSchedule

% = DIVIDE(

SUM('DATA'[LateOnSched]),

CALCULATE(SUM('DATA'[LateOnSched]),

ALLEXCEPT('DATA','DATA'[LateOnSched]))

)

Any help is appreciated 🙂

[davehus · Accepted solution]

Hi @Anonymous ,

Try Below

Row Count = COUNT(Data[LateOnSched])
Supplier Count = CALCULATE([Row Count],ALLEXCEPT(Data,Data[Carrier],Data[Month]))<-Change to Weekl or Month depending on what's in your visual.
% = DIVIDE([Row Count],[Supplier Count])

If this solves your problem, please accept my solution.