Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Cumulative and filtered calculation

Hi Colleagues,   I need again some help 🙂   In the DB we have AVG volume, and we use for visualisaton a line and clustered chart. Tha sales team need another avg (we call it cumulative avg volu...
  • wdx223_Daniel's avatar
    wdx223_Daniel
    3 years ago

     

    AvgCumulativeVolume=DIVIDE(SUMX('Sample','Sample'[Number of days in month]*'Sample'[Volume AVG]),SUM('Sample'[Number of days in month]))

wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
3 years ago

 

AvgCumulativeVolume=DIVIDE(SUMX('Sample','Sample'[Number of days in month]*'Sample'[Volume AVG]),SUM('Sample'[Number of days in month]))

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi wdx223_Daniel,

 

I tried the above mentioned solution in the original datamodel, but it is not works there. 

In the dataset is more then 7 mn rows.

There is a volume column, where we can find eop and avg figures also, and there is a flag, where we can choose the eop and avg. 

 

If i make a matrix, and i drop there the volume avg figures, and the number of days, and i make the multiplication and the division, then i get the correct figures. 

But the above mentioned DAX provides back incorrect figures. 

 

Have you any idea for this issue?

 

Thank you!