Forum Discussion
lbama7k
7 years agoFrequent Visitor
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
- parry2k
Super User