cancel
Showing results for
Did you mean:

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Frequent Visitor

## Percent of Total Counts

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.

1 ACCEPTED SOLUTION
Frequent Visitor

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.

2 REPLIES 2
Super User

Hi @ekroll

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

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.