Forum Discussion
Solved
Explicación Medida Rápida Promedio Anual
Hola me encuentro realizando un estudio de ventas. La idea es realizar un promedio de las ventas anual, me base mucho en una medida rapida que me arrojo power bi pero no entiendo que calculos esta h...
Hi Daxmon_23 ,
The below quick measure will return the average value of [Tiendas Activas]. If you want to get a better understanding on it, you need to know the feature when using the involved functions in the formula: like AVERAGEX, KEEPFILTERS and REMOVEFILTERS etc. You can get the details in the following links.
PromedioVentas =CALCULATE(AVERAGEX(KEEPFILTERS(VALUES('Calendario Fechas'[Date])),CALCULATE([Tiendas Activas])),REMOVEFILTERS('Calendario Fechas'))Best Regards
Hi Daxmon_23 ,
The below quick measure will return the average value of [Tiendas Activas]. If you want to get a better understanding on it, you need to know the feature when using the involved functions in the formula: like AVERAGEX, KEEPFILTERS and REMOVEFILTERS etc. You can get the details in the following links.
PromedioVentas =CALCULATE(AVERAGEX(KEEPFILTERS(VALUES('Calendario Fechas'[Date])),CALCULATE([Tiendas Activas])),REMOVEFILTERS('Calendario Fechas'))
Best Regards