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