Forum Discussion

dramesh18's avatar
dramesh18
Frequent Visitor
8 years ago

RATIO/PERCENTAGE CALCULATION

Hello All

I have data where I need to Calculate Percentage and also have Filters for the data around 6,7.

For example

 

Customer ID WinOrders  TotalOrders Geo            Territory          Segment

12                    5                    9              NA              NA_ENT            Tier1

12212              5                    9              NA_CAN     NA_T2             Tier3

13412              5                    9              NA              NA_T1             Tier2

 

I have to calcualte Percentage for all the GEO level Territory Level Segment Level 

When using powerBI I am unable to get the ratios when I apply filters,

Can anyone help me with this 

Thanks 

Any help/solution is appreciated

Thanks 

Need Help
Show and Tell

2 Replies

    • dramesh18's avatar
      dramesh18
      Frequent Visitor
      8 years ago
       wrote:

      dramesh18

       

      I'm not clear about your expected result. But based on your description, you can use ALLSELECTED() function in your CALCULATE() formula to make the context take the applied filters. Please refer to this article: Understanding ALLSELECTED

       

      Regards,


      Thanks for the link it is helpful but my issue is 

      I have total count, Win count, Price for the products,
      I need to calculate the ratio as 

      Win Ratio = Win Count/Total Count 

      Price Ratio = Price / Win Count and use the filters accordingly.
      Thanks  

       

       

      Thanks any suggestion will be helpful