cancel
Showing results for
Search instead for
Did you mean:
DM_BI 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 Mat YTD_gestión = CALCULATE(COUNT('MAT 18+19+AÑO CERO'[IDCRM]);'MAT 18+19+AÑO CERO'[Estado]<>"Baja";FILTER(ALLSELECTED(DimDate[Año academico]);DimDate[Año academico]="2018/2019");'MAT 18+19+AÑO CERO'[Mes inter_convocatoria]<>"AÑO_CERO";FILTER(ALL('DimDate');'DimDate'[Date] <= MAX('dimdate'[Date])))

Acum Cup YTD_gestión = the running total of the number of leads, which works well also.
Acum Cup YTD_gestión =CALCULATE(COUNT('BI_CUPONES_GESTIONADOS'[cupon_gest_Cliente_id]);FILTER(ALLSELECTED(DimDate[Año academico]);DimDate[Año academico]="2018/2019");'MAT 18+19+AÑO CERO'[Mes inter_convocatoria]<>"AÑO_CERO";FILTER(ALL('DimDate');'DimDate'[Date] <= MAX('dimdate'[Date])))

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.

How to Get Your Question Answered Quickly

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: | |
DM_BI 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

https://wetransfer.com/downloads/7dfa45d3b44a1a0f41def8bb4cc528e420190130094410/5a122b1d0a0a6740b996... Community Support Team

## Re: Running total dividing calculated measures

HI @DM_BI,

I can't get same data from your link, can you please upload it to onedrive/google drive and share link here?

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: | |