count occurence of a text in a column in percentage

[qwertzuiop]

Hello dear Power BI Community

I hope you guys can help me

What is the problem?

Here the initial situation:

TransportID	Arrival
1	Late
2	Early
3	Late
4	Late
5	Early
6	Late

I would like to create four measures to fill the table below.

For the numbers I can use the following measure.

EarlyNumber= COUNTAX(FILTER('Table';[Arrival]="Early");[Arrival])

LateNumber= COUNTAX(FILTER('Table';[Late]="Early");[Arrival])

But now to my question: How can I create a measure to add the percentage occurence (here in red) to the table?

EarlyNumber	EarlyPercentage	LateNumber	LatePercentage
2	33,3 %	4	66,6%

Thank you very much for your help.
Cheers
qwertzuiop

[Anonymous · Accepted solution]

Use below measures,

early = COUNTAX(FILTER('Test',Test[Arrival]="Early"),Test[Arrival])

Early % = [early]/COUNTAX(Test,Test[Arrival])

late = COUNTAX(FILTER('Test',Test[Arrival]="late"),Test[Arrival])

Late % = [late]/COUNTAX(Test,Test[Arrival])

Change format of percent measures to percentage in modelling tab and format.

Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.

[qwertzuiop]

Thank you very much.
Your solution worked as expected.