Forum Discussion
Solved
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...
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]))
This is the sample result that I am looking for,
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]))