Forum Discussion

pbl19's avatar
pbl19
Frequent Visitor
5 years ago

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 ...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Super User
5 years ago

The column names are not in English so i do not understand what you want.  Which is the Category column?  Which is the Sales column?

pbl19's avatar
pbl19
Frequent Visitor
5 years ago

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.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    5 years ago

    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.