Help calculating a percent from of filtered total.

[1001]

Hi, I have a table with two columns:

Col1: Month

Col2: Delivered Sales

I'm trying to claculate the month % for the Delivered Totals of all the filtered months. Just wondering if someone could help.

Thanks.

[ValtteriN · Accepted solution]

Hi,

For this kind of calculation, try utilizing ALLSELECTED.

E.g.

% of total months selected = DIVIDE(

SUM(Aggregation[Duration(Secs)]),

CALCULATE(SUM(Aggregation[Duration(Secs)]),ALLSELECTED(Aggregation[Opened At (Month)]))

)

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/