Hi All,
I am facing difficulty in creating a dashboard. Can anyone help me? Sample File here->https://github.com/ssijbabu/PowerBI
Please find the sample data below.
| Application | Division | Month | Request | Incident |
| App1 | Div1 | 12/01/2018 | 5 | 3 |
| App2 | Div1 | 12/01/2018 | 3 | 7 |
| App3 | Div2 | 12/01/2018 | 8 | 2 |
| App1 | Div1 | 01/01/2019 | 3 | 7 |
| App2 | Div1 | 01/01/2019 | 5 | 2 |
| App3 | Div2 | 01/01/2019 | 8 | 9 |
| App1 | Div1 | 02/01/2019 | 2 | 3 |
| App2 | Div1 | 02/01/2019 | 8 | 5 |
| App3 | Div2 | 02/01/2019 | 5 | 2 |
| App1 | Div1 | 03/01/2019 | 2 | 8 |
| App2 | Div1 | 03/01/2019 | 8 | 4 |
| App3 | Div2 | 03/01/2019 | 3 | 9 |
| App1 | Div1 | 04/01/2019 | 9 | 6 |
| App2 | Div1 | 04/01/2019 | 3 | 7 |
| App3 | Div2 | 04/01/2019 | 6 | 3 |
I am trying to create the following measures
1) Total Tickets - Request + Incident -> Created while loading the Data
2) Last 3 months Total Tickets Avg -> this should be dynamic based on user month selection
3) App Classification -> Calculated based on 3 months avg, if the number fall between 0-5 -Small, 6-10 -Medium, 10-20 -Large.
4) App Cost -> Same as Application classification, if the number fall between 0-5 - $1000, 6-10 -$5000, >10 -$20000.
I am facing problem with 3rd and 4th measure.
I created measure using SWITCH statement, i am getting wrong number in total.
For 3rd measure, no total should be dispalyed. For 4th measure, its not calculating the sum of rows,
So i tried to implement the same in calculated column, but receiving circular dependency error.
Can some one help me how to implement it.
Regards
Sujay
