calculated col
1 Topic
Calculate column percentage from calculated column
I need to calculate the percentage of calculated column B, based on column A +B. I have two calculated columns, each one for a customer segment. A - Column Retention = Customers that had their first purchase before 2021 Formula: Vendas clientes Retenção < 2021 = VAR m = 'Base Clientes e Pedidos'[Data_primeiro_pedido] RETURN CALCULATE(DISTINCTCOUNT('Base Clientes e Pedidos'[id_pedido_promob]), FILTER('Base Clientes e Pedidos', m <= DATE(2021,01,01))) B - Column New Clientes = Customers that had their first purchase after 2021 Formula: Vendas clientes novos >2021 = VAR m = 'Base Clientes e Pedidos'[Data_primeiro_pedido] RETURN CALCULATE(DISTINCTCOUNT('Base Clientes e Pedidos'[id_pedido_promob]), FILTER('Base Clientes e Pedidos', m >= DATE(2021,01,01))) I'm having a hard time to calculate the percentage % of new clients based on the calculated columns. What i need: B/(A+B) I've tried: % Venda para Novos = VAR m = 'Base Clientes e Pedidos'[Data_primeiro_pedido] RETURN DIVIDE(CALCULATE(DISTINCTCOUNT('Base Clientes e Pedidos'[id_pedido_promob]), FILTER('Base Clientes e Pedidos', m >= DATE(2021,01,01) ) ), DISTINCTCOUNT('Base Clientes e Pedidos'[id_pedido_promob]) ) But it doesn't work as expected, returning the value of column B instead of B/(A+B)Solved1.3KViews0likes5Comments