The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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]))
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
User | Count |
---|---|
21 | |
19 | |
18 | |
17 | |
12 |
User | Count |
---|---|
36 | |
34 | |
20 | |
19 | |
15 |