cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper III

## Quartile Calculation - Incorrect values

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.

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!

1 ACCEPTED SOLUTION
Helper III

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]))

2 REPLIES 2
Helper III

This is the sample result that I am looking for,

Helper III

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]))

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.