cancel
Showing results for
Did you mean:
Member

## Running total dividing calculated measures

Hello,

I am facing problem when I want to show the running total of the conversion. To make it simple, the conversion is a calculated measures = sales/leads.

Here is my measure that doesn't work well (see the graph belowI). In bold are my calculated measures :

Acum Conv YTD_Gestión = CALCULATE(DIVIDE([Acum Mat YTD_gestión];[Acum Cup YTD_gestión];0);FILTER(ALLSELECTED(DimDate[Año academico]);DimDate[Año academico]="2018/2019");FILTER(ALL('DimDate');'DimDate'[Date] <= MAX('dimdate'[Date])))

Acum Mat YTD_gestión = the running total of the numbers of sales, which works well.

Acum Cup YTD_gestión = the running total of the number of leads, which works well also.

Do you have any idea why my chart is not showing a running total?

Thank you,
3 REPLIES 3
Community Support Team

## Re: Running total dividing calculated measures

HI @DM_BI,

If you can please share some sample data for test, it will be help for coding formula.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

For learning resources/Release notes, please visit: | |
Member

## Re: Running total dividing calculated measures

Hi Xiaoxin,

Here is a sample I made. You will see that everything is ok except the running total conversion. In january, it should be 20% instead of 15%.

Please let me know if you found where I did wrong!

Thank you very much,

DM

Community Support Team

HI @DM_BI,