percentage calculation

Anujith_unni — Wed, 22 Feb 2023 10:49:42 GMT

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 employee or manager the percentage in number card or other visual is being shown as sum.

for eg its showing while clicking anil as 82% + 89% +98 % = 269 % , but it should view as sum of sales order / sum of total order as percentage

But i need to view that as total percentage?? please give your thoughs

Re: percentage calculation

v-jingzhang — Fri, 24 Feb 2023 02:43:41 GMT

Hi 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.

topic percentage calculation in DAX Commands and Tips

percentage calculation

Re: percentage calculation