Calculate average of a a calculated measure

[Anonymous]

I have a table called orders for which I've created 3 vinculated measures:

% Penetración = [Net Orders]/[Net Order Date]

Net Orders = CALCULATE(DISTINCTCOUNT(ordenes_magento[order_id]),FILTER(ordenes_magento, NOT ordenes_magento[Estado] IN {"Devuelto(100%)", "Cancelado", "Pendiente"}))

Net Order Date = CALCULATE([Net Orders],

ALL('M_A sin EAN duplicados'[SKU]),

ALL('M_A sin EAN duplicados'[EAN]),

ALL('M_A sin EAN duplicados'[descripcion]),

ALL('M_A sin EAN duplicados'[nombre_marca]),

ALL('M_A sin EAN duplicados'[nombre_clase]),

ALL('M_A sin EAN duplicados'[nombre_subnegocio]),

ALL('M_A sin EAN duplicados'[nombre_categoria]),

ALL('M_A sin EAN duplicados'[nombre_subcategoria]),

ALL('M_A sin EAN duplicados'[nombre_segmento]),

ALL('M_A sin EAN duplicados'[category]),

ALL('M_A sin EAN duplicados'[division]),

ALL('M_A sin EAN duplicados'[nombre_subsegmento]),

ALL('M_A sin EAN duplicados'[bfpp]),

ALL('M_A sin EAN duplicados'[formato]),

ALL(ordenes_magento[formato_venta]),

ALL(ordenes_magento[sku_consolidado]),

ALL(ordenes_magento[detalle_formato_venta]),

ALL(ordenes_magento[descripcion_tipo_venta]),

ALL(clientes_magento[rango_edad])

)

My goal is to create another measure that will hold a single scalar value and will be the average of '% Penetration' for the period filtered.

Can you help me please?

[Ashish_Mathur]

Hi,

What result do you get when you drag the % penetration measure to a card visual? 

[Anonymous · Accepted solution]

Hi @Anonymous ,
Thanks for @NaveenGandhi reply.
According to your description, you want to count the data that is not within the three states and calculate the total amount of data, and finally calculate the percentage number.
Here is my test data and steps

Create measures

Net Order Date = COUNTROWS(orders_magento)

Net Orders = CALCULATE(DISTINCTCOUNT(orders_magento[order_id]),FILTER(orders_magento, NOT orders_magento[Status] IN {"Returned(100%)", "Cancelled", "Pending"}))

% Penetration = [Net Orders]/[Net Order Date]

Final output

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[NaveenGandhi]

Hi @Anonymous 

please share sample data and expected output( attach screenshots too) to understand the problem better.

Thanks,
NG