Accumulate Values per day

---

ROBERTOCMRNO wrote:

 

 

Hi!

I need a little help about a question. I´m doing a expression to calculate a value accumulate from day. 

Expression atual:

AOP_ = CALCULATE([Actual (R$)];FILTER(ALLSELECTED(V_RELATORIOVENDAS_[DataInclusao]);V_RELATORIOVENDAS_[DataInclusao] <= MAX(V_RELATORIOVENDAS_[DataInclusao]) && V_RELATORIOVENDAS_[DataInclusao] <= TODAY()))

Graphic.

My AOP should be: Day 1, example, 2%, in Day 2 we have more 3%, then, in the Day 2 AOP = 5%.

 

Who can help me about his???

 

Thank you!

---

ROBERTOCMRNO

What is the measure [Actual (R$)]? You can try below measure

AOP_ =
CALCULATE (
    [Actual (R$)],
    FILTER (
        ALLSELECTED ( V_RELATORIOVENDAS_),
        V_RELATORIOVENDAS_[DataInclusao] <= MAX ( V_RELATORIOVENDAS_[DataInclusao] )
            && V_RELATORIOVENDAS_[DataInclusao] <= TODAY ()
    )
)