Forum Discussion
percentage calculation
Hi everyone. i have manager and employee - sales order, total sales order(sales order/total sales order = sales %) sales percentage is there where every employee is continuous, while clicking an ...
v-jingzhang
Community Support
Community SupportHi Anujith_unni
Your current order% is a column so its data is fixed and cannot return the correct % of totals. To have the expected result, you need to create a measure to calcualte the percentage instead. A measure can be dynamic according to the filter context.
Suppose your table is called Sales, you can create the following measure:
Order pencentage = DIVIDE ( SUM ( 'Sales'[Sales Order] ), SUM ( 'Sales'[total Sales order] ) )
Measures in Power BI Desktop - Power BI | Microsoft Learn
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.