DAX Formula for Cumulative and %Cumulative

melq64

New Member
Hi,

I have the following dax formulas for my cumulative total and % cumulative. Its working but not showing the correct cumulative in the technical sense

Total Items Delivered:
TotalItemsDelivered:=CALCULATE(COUNTROWS('DistProfile v1-3'),FILTER('DistProfile v1-3','DistProfile v1-3'[DeliveryDate]<>BLANK()))

Cumulative Total Items Delivered:
CumulativeTotalDelivered:=IF(MIN(dCalenderDelivery[Date])>CALCULATE(MAX('DistProfile v1-3'[DeliveryDate]),ALL('DistProfile v1-3')),BLANK(),CALCULATE(COUNTROWS('DistProfile v1-3'),FILTER(ALL(dCalenderDelivery),dCalenderDelivery[Date]<=MAX(dCalenderDelivery[Date]))))


%Cumulative Total Items Delivered:
%CumulativeTotalDelivered:=DIVIDE([CumulativeTotalDelivered],CALCULATE([CumulativeTotalDelivered],ALLSELECTED('DistProfile v1-3'[Delivery Days])))


Here is screenshot of the output pivot table based on the above % Cumulative formula:

https://drive.google.com/file/d/1weSOA0OxIu5QiC5WU_Q_TMK2DWZhhrnk/view?usp=sharing


Appreciate any help:)
 

Some videos you may like

This Week's Hot Topics

Top