I posted this problem earlier but my post wasn't particularly clear.
I have a KPI calculation which involves a count as per below
IF([Incident Category]='RTA',((Count (DISTINCT [V.I.R. Number]) / (sum([Scheduled Miles Value]))
This works perfectly on a monthly basis but I am unable to get this to work on a YTD basis.
I have a flag system in place for my YTD calcs, (Met Pd) is our refernce for month. But I am unable to adapt the formula with the KPI calc to give me the result I want.
