Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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]))
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 17 | |
| 8 | |
| 4 | |
| 3 | |
| 3 |
| User | Count |
|---|---|
| 27 | |
| 18 | |
| 12 | |
| 11 | |
| 11 |