Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. 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 |
---|---|
18 | |
18 | |
14 | |
13 | |
13 |
User | Count |
---|---|
17 | |
14 | |
11 | |
10 | |
8 |