topic Quartile Calculation - Incorrect values in DAX Commands and Tips

Quartile Calculation - Incorrect values

Sri_phani — Sat, 13 Jul 2024 15:55:46 GMT

Hi,

I am trying to show the month-on-month Quartiles for the metric called Resolve. Below is the measure I am trying to use, when the single month is selected the result seems to be accurate but when we remove the month filter then results are not accurate.

Can you please help me with this.

Res% Quartile =

VAR AgentScore = [Resolve]

VAR FilteredData_1 = ALLSELECTED('1_Core Raw data'[Start of Month],'1_Core Raw data'[Final Team manager])

VAR Result_1 =

IF(NOT ISBLANK(AgentScore),SWITCH(

TRUE(),

AgentScore >= PERCENTILEX.INC(FilteredData_1, [Resolve], 0.75), "Q1",

AgentScore >= PERCENTILEX.INC(FilteredData_1, [Resolve], 0.50), "Q2",

AgentScore >= PERCENTILEX.INC(FilteredData_1, [Resolve], 0.25), "Q3",

AgentScore >= PERCENTILEX.INC(FilteredData_1, [Resolve], 0), "Q4"))

RETURN

Result_1

Thank!

Re: Quartile Calculation - Incorrect values

Sri_phani — Sat, 13 Jul 2024 16:00:32 GMT

This is the sample result that I am looking for,

Re: Quartile Calculation - Incorrect values

Sri_phani — Sat, 13 Jul 2024 17:29:32 GMT

Issue is resolved one of my friend helped me with Filter function.

FilteredData_1 = FILTER(ALLSELECTED('1_Core Raw data'[Start of Month],'1_Core Raw data'[agent_email],'1_Core Raw data'[Final Team manager]),'1_Core Raw data'[Start of Month]=SELECTEDVALUE('1_Core Raw data'[Start of Month]))