Quartiles of a measure

[Anonymous]

Greetings,

I am starting with power BI, and need your help for how to calculte quartiles for a measure calculated based on two elements from two tables.

Like in the example in the file bellow :

https://docs.google.com/spreadsheets/d/1QG0riZ9jzy1o485sgfUkvrZcTPmMnOQp/edit?usp=sharing&ouid=10458...

I have 3 tables,

- LAG : that identify agents names based on ID and Date.

- Calls : That Gets me number of calls by ID & Date.

- Sales : That Gets me Sales by ID & Date.

And all tables are related by "LAG" that contains a key that combines "ID & DATE".

The Measure i use is a KPI used in my compagny called "Sales/Calls" :

Sales/Calls = DIVIDE (sum(sum('Sales'[Sales]),sum(Calls'[Calls]),0)

I need to Get the dynamic quartiles for this measure that can interact with sliders & segments so i can by that get the List of the TOP 25% performers and the Least 25% Performers and the two populations in-between.

Thanks in advance.

[v-yalanwu-msft]

Hi, @Anonymous ;

Is your problem solved? If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-yalanwu-msft]

Hi, @Anonymous ;

I have modified your formula, but I do not understand what you want the output to mean by the dynamic quartile?

Sales/Calls = DIVIDE (sum('Sales'[Sales]),SUM('Calls'[Calls]),0)

The final show:

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.