Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I made a dashboard where i have a KPI thats uses the %GT Count of ID. also adding a goal. Works like a charm and gives great insights.
I also have a filter per month. So when i select January i can see they made 92.40% and thats is above 90% wich is good, green.
February they did 87% and it turns red, because its lower than 90%.
Now i'd like to remove the month filter and show the % in a linegraph. However if i use %GT count of ID in a linechart i get about 8,50% each month. Because it then calculates howmuch January did for the GT instead of the GT of january.
I hope my question is clear this way, if not feel free to ask for clarification.
Thanks.
Quality over Quantity
Solved! Go to Solution.
Hi @EricHulshof ,
Maybe you could try this:
% Count of Madeit number = DIVIDE ( CALCULATE ( COUNTROWS ( 'Table' ), 'Table'[Madeit] = "TRUE" ), COUNTROWS ( 'Table' ) )
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
So lets see.
i have incidents; shaped something like this:
ID | DateReported | Date Resolved | Priority | TargetDate | Madeit |
1 | 10-10-2019 | 10-10-2019 | 2 | 11-10-2019 | TRUE |
2 | 11-10-2019 | 15-10-2019 | 2 | 12-10-2019 | FALSE |
3 | 15-10-2019 | 16-10-2019 | 2 | 16-10-2019 | TRUE |
4 | 15-10-2019 | 15-10-2019 | 2 | 16-10-2019 | TRUE |
5 | 15-10-2019 | 17-10-2019 | 2 | 16-10-2019 | FALSE |
6 | 10-9-2019 | 10-9-2019 | 2 | 11-9-2019 | TRUE |
7 | 11-9-2019 | 15-9-2019 | 2 | 12-9-2019 | FALSE |
8 | 15-9-2019 | 16-9-2019 | 2 | 16-9-2019 | TRUE |
9 | 15-9-2019 | 15-9-2019 | 2 | 16-9-2019 | TRUE |
10 | 15-9-2019 | 15-9-2019 | 2 | 16-9-2019 | TRUE |
As you can see the total KPI for this would be 70%. As 70% is on time (7/10 times true).
When i filter on september the KPI would turn to 80% as i have 4/5 on time. for october it would turn to 60% (3/5)
Now i try to get these values in a line chart. (Sept 80% to oct 60%) so i can see in what months it went over the desired KPI %)
For screenshots: i currently have the KPI like this:
As you can see i can not just use %GT count again. Since it just splits the 82% between the months.
I hope this clarifies the problem. Thankyou.
Quality over Quantity
Hi @EricHulshof ,
Maybe you could try this:
% Count of Madeit number = DIVIDE ( CALCULATE ( COUNTROWS ( 'Table' ), 'Table'[Madeit] = "TRUE" ), COUNTROWS ( 'Table' ) )
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |