Percent of Total Counts

[ekroll]

I'm having some trouble understanding how to get the percent of a total count for category.

I have a measure that counts the rows for a given criteria (where the days late are >=1).

What I need to do is provide the percent Total_Carrier_Lates per carrier compared to the total of all Total_Carrier_Lates:

So in the table above, I'm look to add a new column that says late weighting... row 1 would be 6614/12621...

How do I get the sum of the total counts?

Every example I've seen uses SUM to add some thing like a sales amount column, but I need to count the instances that match the critera and then add those up?

My measure counting the late shipments is:

Total_Carrier_Lates = CALCULATE(

    COUNTROWS('EAP LTL Shipments'),

    'EAP LTL Shipments'[DaysLate]>=1,

    'EAP LTL Shipments'[Carrier_Responsible]=TRUE

    )

Appreciate any help.

[tamerj1]

Hi @ekroll 

please try

% Late =
DIVIDE (
    [Total_Carrier_Lates],
    CALCULATE ( [Total_Carrier_Lates], ALL ( 'EAP LTL Shipments'[Category] ) )
)

[ekroll · Accepted solution]

Probably should have known it would click after posting....

SumLates =

var total_late = CALCULATE(

    COUNTROWS('EAP LTL Shipments'),

    'EAP LTL Shipments'[DaysLate]>=1,

    'EAP LTL Shipments'[Carrier_Responsible]=TRUE,

    ALL('EAP LTL Shipments')

    )

return

 DIVIDE([Carrier_Lates],total_late)

Seems to give me what I'm looking for.