Forum Discussion

DM_BI's avatar
DM_BI
Icon for Helper III rankHelper III
7 years ago

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