NEED Help

[Anonymous]

Hello guys, 

I m facing problem while applying formula

Problem is : i have actual sales and expected sales of different salesperson. Expected sale is in the form of range (Ex- 20-20K, 20-30K etc). I have to see how many sales person are able to get his expected sales. and if his sales is below than expected sales then i should get 0 corresponding to his exopected sales range. that is 0 person achive this target

EX- Actual sales 10K, Expected sales is 5K-15K, i have 100 sales person. now how can i write a formula so that i can see how many of salesperson out of 100 is capable of meeting his target 5K-15K .

Please guide!

[v-shex-msft]

Hi @Anonymous,

Most of edit functions(include create measure and columns) has been disabled on service side. Please create report on power bi desktop then publish to power bi service.

Sample steps:

1. Create calculated column to check current sales range as category.
2. Use above category column and person id with count of person id to create visual.

If you are confused on coding formula, please share some sample data for test.

Regards,

Xiaoxin Sheng