Forum Discussion

Anujith_unni's avatar
Anujith_unni
New Member
3 years ago

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

 

 

 

1 Reply

  • v-jingzhang's avatar
    v-jingzhang
    Icon for Community Support rankCommunity Support
    3 years ago

    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.