Percentage by category based on category status

[elle-queue]

Hi all - I'm trying to get a percentage of overdue registrations per category.  A data sample is below.  The registrations should be counted, not summed.

Category	Status	Registration
Apple	Not Due	4600
Orange	Not Due	4218
Pear	Overdue	4696
Strawberry	Overdue	4215
Orange	Overdue	4050
Pear	Not Due	4491
Apple	Overdue	3291
Strawberry	Not Due	2026
Strawberry	Not Due	2365
Apple	Not Due	2943
Strawberry	Overdue	2247
Pear	Not Due	4143
Orange	Overdue	2353
Orange	Not Due	2010
Pear	Not Due	3502

If I manually perform the calcuation in Excel, it looks like this:

	Status
Category	Not Due	Overdue	TOTAL	% Overdue
Apple	2	1	3	33%
Orange	2	2	4	50%
Pear	3	1	4	25%
Strawberry	2	2	4	50%

The answer I'm looking for is highlighted red above.  I tried, couldn't figure it out LOL.  Any help is appreciated, many thanks.

[Kedar_Pande]

@elle-queue 

CountOverdue = 
CALCULATE(
COUNT('YourTable'[Registration]),
'YourTable'[Status] = "Overdue"
)

TotalRegistrations = 
CALCULATE(
COUNT('YourTable'[Registration])
)

PercentageOverdue = 
DIVIDE([CountOverdue], [TotalRegistrations], 0) * 100

💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn

[elle-queue]

thank you so much @Kedar_Pande 

[FreemanZ · Accepted solution]

hi @elle-queue ,

plot a measure like:

%Overdue = 
VAR _overdue =
    COUNTROWS(    
        FILTER(
            data,     
            data[status]="Overdue"
        )
    )
VAR _total = COUNTROWS(data)
RETURN DIVIDE(_overdue, _total)

it worked like:

[elle-queue]

Thanks you @FreemanZ 

[HamedM1125]

@FreemanZ  The file you shared is not downloading, can you reshare it? Thanks!

[FreemanZ]

hi @HamedM1125 ,

thanks for the feedback. could you try it again?

[HamedM1125]

@elle-queue 

You can try the following measure:

Total Percentage = DIVIDE(

                            COUNT('Table'[Status]),

                            CALCULATE(

                                    COUNT('Table'[Status]),

                                    ALLEXCEPT('Table','Table'[Category])),

                                    0)

Let me know if that works. Kudos!

[elle-queue]

Thank you @HamedM1125 .  This isn't exactly what I was wanting, but I can see how it could be useful for something else i'm working on, so thank you!