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          Segmen...
Need Help
Show and Tell
v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
8 years ago

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,

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