Forum Discussion
Calculate performance
Dear all, I've been trying to calculate performances of my time without success.. please help! I have a data series like this: Case created date Performance of closed case 2-Jan-18 On ...
Measure 13 = VAR __onTime = COUNTX(FILTER('Table13',[Performance of closed case]="On time"),[Performance of closed case]) VAR __all = COUNTX(ALL('Table13'),[Performance of closed case]) RETURN DIVIDE(__onTime,__all,0)See Page 6 of the attached file.
Thanks for the quick reply. Unfortunately this doesn't work with my file. See below. My file has a lot more columns and several different date columns. Would that be a problem? Should I create a new table withextracting just these 2 columns (if so, how do I do that)? Thanks a lot.
Its showing as 0 because the measure needs to formatted as Percentage from the Modelling tab