Forum Discussion

lbama7k's avatar
lbama7k
Frequent Visitor
7 years ago

filter line graphic

Hello,

 

I have a problem, I need to make a line graphic with "Var.Ofertas" by "año_semana" of the following table (photo):

 

cotizaciones= sum('Autos PBI_conv_resumen_semanal'[Cotizaciones])

 

ofertas anteriores=CALCULATE(sum('Autos PBI_conv_resumen_semanal'[Cotizaciones]);FILTER(ALLSELECTED('Autos PBI_conv_resumen_semanal');'Autos PBI_conv_resumen_semanal'[rank]=max('Autos PBI_conv_resumen_semanal'[rank])-1)

 

Var.Ofertas= cotizaciones/cotizaciones -1

 

When I insert the graphic, I can't filter "Infinity" because I always have one "Infinity".  Can you help me?

thanks!

 

1 Reply