Forum Discussion
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
- Ashish_Mathur
Super User
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.