Running total issu

[Anonymous]

Hello,

I had created a running total and it worked just fine with filters but now I am developing a new dashaboard and I recreated the same measure but it is not working. Whenever I apply a filter it shows only blanks values.

I have been trying to figure it out on my own but I ended up with nothing.

Mesure 1:

Rank Motivos 3 =

IF(HASONEVALUE(Motivos[Motivo]),

RANKX(ALLSELECTED(Motivos[Motivo]),

RANKX(ALLSELECTED(Motivos[Motivo]),[N° Incidencias Efectivas])

+DIVIDE(

RANKX(ALLSELECTED(Motivos[Motivo]),[Total Pedido]), (COUNTROWS(ALLSELECTED(Motivos[Motivo]))+1)

)

,,ASC),

BLANK())

Measure2

Running Total = CALCULATE(SUM(Incidencias_final[count]),

TOPN([Rank Motivos 3],ALLSELECTED(Motivos[Motivo]),[Rank Motivos 3], ASC))

https://intercorpretail-my.sharepoint.com/:u:/g/personal/aleksei_diaz_irdigital_pe/EULyhbtkckBNukcOv...