Forum Discussion
Problem with Cumulative Total% - Category ABC
Hi, I'm at an absolute loss as to how to calculate a cumulative total. I've tried googling, reading the forums, following the documentation, decomposing the calculation, but my measure always fails ...
hi Ashish_Mathur ,
Sales Column is TOTALITEM_CI.
The category measure will be created based on the cumulative percentage measure. (80/20 pareto).
DIM_ARTICULO --> Product Table
DIM_SUCURSAL -- > branch table
Thank you.
Hi,
Because of the sheer size of the Data, time taken to process is very high. I wrote these 2 measures
Rank = RANKX(ALL(DIM_ARTICULO[ART_ID]),[SALES],,0,SKIP)Cumulative revenue = SUMX(TOPN([Rank],CALCULATETABLE(VALUES(DIM_ARTICULO[ART_ID]),ALL(DIM_ARTICULO[ART_ID])),[SALES]),[SALES])When i dragged the second measure to the visual, it did not appear in the visual.
Sorry but cannot help here.