Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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.
Thank!
Solved! Go to Solution.
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]))
User | Count |
---|---|
21 | |
14 | |
11 | |
8 | |
5 |
User | Count |
---|---|
24 | |
22 | |
20 | |
15 | |
10 |