Forum Discussion
cumulative target line
Resident Rockstar#Employees should be a measure, not a calculated column. Calculated columns are only re-calculated on data refresh. Measures are re-evaluated every time they are used.
Okay. When I do the # employees as a measure, my calucation for the Rate column (Rate=MAX('Employees'[#employees calc])*5/365) breaks and I get a message saying that it can't be used in this expression. If I take out the MAX function, instead of having a constant rate for each day, Power BI is dividing what should be the total for 1 day (~7) over 365 days, and the value is not constant for every day (screenshot below). If I take the "/365" out of that formula, it's still giving me inconsistent numbers throughout that column. And it's still not affected by filtering by employee.
- MFelix
Super User
Hi toniacheung ,
Did you try to use my measure as I posted before? On the tests I did the cumulative when ok.
Regards,
MFelix
I did try that cumulative formula. It's also giving me variable small numbers for each day, with some rows blank. And the numbers don't make sense for the data it's supposed be calculating.
- MFelixWhat is suppose to be the value oer day?
You refer you have 5 reports per year making this a daily measure and as you refer 5/365 = 0,013.
In my opinion this is not the best way to show the target for this type of information.
Considering only 1 person the target for the full year is 5 doesn't matter of he is on January 1 of December 31st because making the split of reporting troughout the year seems odd to me.
Can you elaborate more on what you want to compare and follow up?
Regards,
MFelix
