Percent of Column Total

[KaitlynS4]

I would like to find the percent of the TonsDeliveredLate by Carrier Delay from the Total TonsReported.

Example: 2,430 tons of Carrier Related Delays / 70,580 Total Tons Reported

I created the following 'New Measure', but it's only finding percentages by the row. (Carrier Related TonsDeliveredLate/Carrier Related TonsReported)  I need it to find a row percentage of a column total.

Percent = SUM(Shipments[TonsDeliveredLate])/SUM(Shipments[TonsReported])*100

[v-frfei-msft · Accepted solution]

Hi @KaitlynS4,

Did you filter the table visual? Then please use the formula to work on it.

Measure = CALCULATE(SUM(Table1[TonsDeliveredlate]))/CALCULATE(SUM(Table1[TonsReported]),ALLSELECTED(Table1))

If it doesn't meet your requirement either, kindly share your pbix to me.

Regards,

Frank

[v-frfei-msft]

Hi @KaitlynS4,

One sample for your reference. Here we need to create a measure to work on it.

Measure = CALCULATE(SUM(Table1[TonsDeliveredlate]))/CALCULATE(SUM(Table1[TonsReported]),ALL(Table1))

Also please find the pbix as attached.

Regards,

Frank

[KaitlynS4]

My calculations still don't look right.  For Carrier Related, the Measure should be 2,591/71,434 = .0362 *100 = 3.63.  However, this calucation is coming up as 2.44

I just copied your measure for the calculations, so I'm not sure how it could be different?

[v-frfei-msft · Accepted solution]

Hi @KaitlynS4,

Did you filter the table visual? Then please use the formula to work on it.

Measure = CALCULATE(SUM(Table1[TonsDeliveredlate]))/CALCULATE(SUM(Table1[TonsReported]),ALLSELECTED(Table1))

If it doesn't meet your requirement either, kindly share your pbix to me.

Regards,

Frank

[v-frfei-msft · Accepted solution]

Hi @KaitlynS4,

Does that make sense? If so, kindly mark my answer as a solution to close the case.

Regards,
Frank