calculated columns based on condition

[mdevm]

Hi, I have sample data as above. I want to add calculated columns for below based on Associate and Opportunity Number fields in data above. 

1. Number of associates who created 0 opportunity

2. Number of associates who created 1-5 opportunity

3. Number of associates who created 10 opportunity

4. Number of associates who created 10+ opportunity

can someone assist , thanks. 

[v-jingzhang]

Hi @mdevm , can you share some sample data (remove sensitive info) and expected result with the conditions?

[manikumar34]

@mdevm , You can create a calculated column by usin nested IF condition or a measure with SWITCH case. 

Regards, 

Manikumar

[Ashish_Mathur]

Hi,

It should be possible to solve this question with a measure.  Share some data to work with. 

[parry2k]

@mdevm solution is attached, tweak it as your feel like.

Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡