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
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi  pbl19 ,

You can create these measures.

Sale =CALCULATE(SUM('FT_STOCKVENTA'[TOTALITEM_CI]),FILTER(ALL('DIM_ARTICULO'),'DIM_ARTICULO'[ART_ID]=MAX('DIM_ARTICULO'[ART_ID])))
Cumulativesales =CALCULATE(SUM('FT_STOCKVENTA'[TOTALITEM_CI]),FILTER(ALL('DIM_ARTICULO'),'DIM_ARTICULO'[ART_ID]<=MAX('DIM_ARTICULO'[ART_ID])))
Cumulativesale% =
DIVIDE([Sale],[Cumulativesales])
Category=
IF(
    [Cumulativesale%]>+0&&[Cumulativesale%]<=0.8,"A","B")

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • pbl19's avatar
    pbl19
    Frequent Visitor
    5 years ago

    Thanks u Liu for your comment,  but when i dragged the measurements to the visual, it crashed.