Breaking down into quartiles

[Anonymous]

Hi all, 

I am trying to create a Mesure which will return how many employees per month are in each quartile based on the Hourly rate. 

I have a CalendarTable and a Data Table linked with inactive interaction. 

On my Data table my data are linke : 

DATE	ID	hourly rate
01/01/2021	1	9.01
01/01/2021	2	10.5
01/01/2021	3	10.5
01/01/2021	4	13.8
01/01/2021	5	8.95
01/01/2021	6	20
01/01/2021	7	16.37
01/01/2021	8	15
01/01/2021	9	12
01/01/2021	10	9.01
01/02/2021	1	9.01
01/02/2021	2	10.5
01/02/2021	3	10.5
01/02/2021	4	13.8
01/02/2021	5	8.95
01/02/2021	6	20
01/02/2021	7	16.37
01/02/2021	8	15
01/02/2021	9	12
01/02/2021	10	9.01
01/03/2021	1	10
01/03/2021	2	11.2
01/03/2021	3	11.2
01/03/2021	4	17
01/03/2021	5	10
01/03/2021	6	11
01/03/2021	7	18
01/03/2021	8	17
01/03/2021	9	13
01/03/2021	10	12.52

So When I select JAN 2021 (the slicer is based in the calendar date) i'd like to get back 

Q1	3
Q2	2
Q3	3
Q4	2

How can i achive it ? 

[amitchandak]

@Anonymous , You need one or two date table, one of them should be an independent date table

when you select less and want to show more, then you need independent  tbale.

refer to this video: https://www.youtube.com/watch?v=duMSovyosXE

[Anonymous]

Hi @amitchandak. 

I managed to create a measure to get the each quartile value

Q1 = CALCULATE(PERCENTILE.INC(Remuneration[Ordinary (hour)], .25), ALL(Remuneration[Ordinary (hour)]),USERELATIONSHIP(_Calendar[DATE], Remuneration[DATE])) 

Now i am trying to count how many employees are below this figure. 

[v-yiruan-msft · Accepted solution]

Hi @Anonymous ,

I created a sample pbix file (see attachment), please check whether that is what you want.

Best Regards

[Anonymous]

It worked like a glove. 

thanks @v-yiruan-msft