Hi,
I've created measure to calculate cumulative % which is based on 3 measures as shown below. However the result of the cumulative % does not look right (refer to image links below).
Please note that the resulting image table in the links below shows 2 screenshots: one with negative values included and the 2nd image without negative values i.e. filtered out. Would appreciate any feedback. Thanks
TotalItemsDelivered:=CALCULATE(COUNTROWS('DistProfile v1-3'),FILTER('DistProfile v1-3','DistProfile v1-3'[Delivery]<>BLANK()))
CumulativeTotalDelivered:=CALCULATE([TotalItemsDelivered],FILTER(ALL(dCalenderDel),dCalenderDel[Date]<=MAX(dCalenderDel[Date])),VALUES(dCalenderDel[Date]))
%CumulativeTotalDelivered:=DIVIDE([CumulativeTotalDelivered],CALCULATE([CumulativeTotalDelivered],ALLEXCEPT(dCalenderDel,dCalenderDel[Year])))
https://drive.google.com/open?id=1VM0S0lQJS24woYvvEP4F2I_-5NhSZWwF
https://drive.google.com/open?id=136t4qMpK9trGYiqvy4mjJHJB7vCgV3lJ
I've created measure to calculate cumulative % which is based on 3 measures as shown below. However the result of the cumulative % does not look right (refer to image links below).
Please note that the resulting image table in the links below shows 2 screenshots: one with negative values included and the 2nd image without negative values i.e. filtered out. Would appreciate any feedback. Thanks
TotalItemsDelivered:=CALCULATE(COUNTROWS('DistProfile v1-3'),FILTER('DistProfile v1-3','DistProfile v1-3'[Delivery]<>BLANK()))
CumulativeTotalDelivered:=CALCULATE([TotalItemsDelivered],FILTER(ALL(dCalenderDel),dCalenderDel[Date]<=MAX(dCalenderDel[Date])),VALUES(dCalenderDel[Date]))
%CumulativeTotalDelivered:=DIVIDE([CumulativeTotalDelivered],CALCULATE([CumulativeTotalDelivered],ALLEXCEPT(dCalenderDel,dCalenderDel[Year])))
https://drive.google.com/open?id=1VM0S0lQJS24woYvvEP4F2I_-5NhSZWwF
https://drive.google.com/open?id=136t4qMpK9trGYiqvy4mjJHJB7vCgV3lJ
