Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Percent Total for each month

Hello,

 

I would like to caculate the percent total of jobs with a JobTimeSpan equal to or below 24 per month. Ideally I want to use a column chart with Month-Year on x axis with %total as the y-axis. I am using the below measures but it calculates the % of all months rather than each individual month. 

 

Total Jobs: COUNTA(Request Name)

All Jobs: CALCULATE([Total Jobs], ALLSELECTED(Jobs)

%Total: DIVIDE([Total Jobs], [All Jobs], 0)

 

 

 

For example, on the matrix above how can I get each month's total to show as 100% instead? 

 

Thank you in advance!

 

  • Hi,

    Does this measure work?

    All Jobs = CALCULATE([Total Jobs], ALLSELECTED(Jobs[JobTimeSpan]))

    If not, then share the link from where i can download the PBI file.

1 Reply

  • Hi,

    Does this measure work?

    All Jobs = CALCULATE([Total Jobs], ALLSELECTED(Jobs[JobTimeSpan]))

    If not, then share the link from where i can download the PBI file.