Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I have a collection of data which the results is either displayed as "Approved" or "Rejected" in a week report query.
In Power BI using DAX measure how would I calcuate the percentage of rejections of the total volume being received per. week ?
Thank you in advance for any help,
Don
WEEK | C_ID | RESULTS |
17 | 000000657520 | Approved |
19 | 000000657520 | Approved |
12 | 000000105257 | Approved |
10 | 000000142235 | Approved |
25 | 000000342207 | Approved |
2 | 000000350383 | Approved |
7 | 000000375003 | Approved |
2 | 000000409683 | Approved |
18 | 000000419944 | Approved |
4 | 000000419944 | Rejected |
17 | 000000416963 | Approved |
15 | 000000424073 | Approved |
8 | 000000421613 | Approved |
16 | 000000421704 | Approved |
14 | 000000429461 | Rejected |
4 | 000000432030 | Approved |
2 | 000000430685 | Approved |
21 | 000000428503 | Approved |
9 | 000000428349 | Rejected |
21 | 000000427792 | Approved |
21 | 000000450926 | Approved |
11 | 000000434513 | Approved |
8 | 000000450935 | Approved |
8 | 000000432420 | Approved |
18 | 000000438565 | Approved |
9 | 000000439147 | Approved |
19 | 000000435329 | Approved |
16 | 000000438210 | Approved |
8 | 000000437524 | Approved |
20 | 000000437080 | Approved |
25 | 000000437091 | Approved |
15 | 000000437349 | Approved |
1 | 000000437472 | Approved |
23 | 000000436848 | Rejected |
2 | 000000439186 | Approved |
21 | 000000439186 | Approved |
17 | 000000435332 | Approved |
12 | 000000434990 | Approved |
11 | 000000436361 | Approved |
23 | 000000439910 | Approved |
10 | 000000440783 | Rejected |
6 | 000000439539 | Approved |
25 | 000000438530 | Approved |
20 | 000000438101 | Rejected |
8 | 000000440621 | Approved |
24 | 000000437250 | Approved |
7 | 000000439590 | Approved |
4 | 000000435520 | Approved |
10 | 000000438885 | Approved |
16 | 000000441171 | Approved |
7 | 000000438874 | Approved |
10 | 000000436886 | Approved |
11 | 000000443684 | Approved |
19 | 000000445125 | Approved |
17 | 000000446495 | Approved |
23 | 000000448819 | Approved |
24 | 000000448644 | Rejected |
25 | 000000446701 | Approved |
8 | 000000441819 | Rejected |
3 | 000000447106 | Approved |
12 | 000000444961 | Approved |
9 | 000000448633 | Approved |
21 | 000000446808 | Approved |
14 | 000000441973 | Approved |
23 | 000000442388 | Approved |
4 | 000000443774 | Approved |
17 | 000000446420 | Approved |
4 | 000000444496 | Rejected |
18 | 000000447702 | Approved |
11 | 000000445675 | Approved |
13 | 000000445675 | Rejected |
12 | 000000446974 | Approved |
4 | 000000447633 | Approved |
13 | 000000448403 | Rejected |
11 | 000000449109 | Approved |
21 | 000000450859 | Approved |
23 | 000000450783 | Approved |
1 | 000000449324 | Approved |
9 | 000000453372 | Approved |
9 | 000000657423 | Approved |
1 | 000000453855 | Approved |
24 | 000000453794 | Approved |
18 | 000000451741 | Approved |
8 | 000000452333 | Rejected |
24 | 000000452102 | Approved |
13 | 000000452621 | Approved |
18 | 000000454813 | Approved |
20 | 000000451704 | Approved |
6 | 000000454255 | Rejected |
15 | 000000449084 | Approved |
14 | 000000448910 | Approved |
19 | 000000448910 | Approved |
10 | 000000453596 | Approved |
14 | 000000449049 | Approved |
12 | 000000458051 | Approved |
15 | 000000456611 | Approved |
10 | 000000456549 | Approved |
20 | 000000456684 | Approved |
25 | 000000457809 | Rejected |
18 | 000000458508 | Approved |
23 | 000000455989 | Approved |
1 | 000000457273 | Approved |
11 | 000000462038 | Approved |
6 | 000000460156 | Approved |
9 | 000000457134 | Approved |
19 | 000000458432 | Approved |
23 | 000000461973 | Approved |
4 | 000000455947 | Approved |
11 | 000000456806 | Approved |
22 | 000000459339 | Approved |
19 | 000000455861 | Approved |
24 | 000000458507 | Approved |
1 | 000000461312 | Rejected |
10 | 000000457698 | Approved |
13 | 000000465485 | Approved |
6 | 000000459467 | Approved |
22 | 000000457551 | Rejected |
17 | 000000458868 | Approved |
25 | 000000462496 | Approved |
5 | 000000456161 | Approved |
4 | 000000456161 | Approved |
22 | 000000462063 | Approved |
17 | 000000456293 | Approved |
9 | 000000461516 | Rejected |
15 | 000000460913 | Approved |
14 | 000000455369 | Approved |
13 | 000000459420 | Approved |
12 | 000000457466 | Approved |
5 | 000000464929 | Approved |
15 | 000000464953 | Approved |
24 | 000000465893 | Approved |
1 | 000000464074 | Approved |
18 | 000000464678 | Approved |
23 | 000000465509 | Approved |
17 | 000000465323 | Approved |
4 | 000000462866 | Approved |
10 | 000000462964 | Approved |
8 | 000000462917 | Approved |
3 | 000000467581 | Approved |
15 | 000000463055 | Rejected |
10 | 000000463292 | Approved |
22 | 000000467541 | Approved |
18 | 000000466910 | Approved |
7 | 000000467639 | Approved |
9 | 000000467729 | Approved |
4 | 000000467591 | Approved |
25 | 000000466340 | Approved |
17 | 000000468693 | Approved |
25 | 000000468503 | Rejected |
14 | 000000467010 | Approved |
1 | 000000468477 | Approved |
24 | 000000466028 | Approved |
12 | 000000469419 | Rejected |
18 | 000000464819 | Approved |
13 | 000000466743 | Approved |
23 | 000000467850 | Approved |
15 | 000000466805 | Approved |
22 | 000000466841 | Approved |
10 | 000000468390 | Approved |
6 | 000000467513 | Approved |
10 | 000000469928 | Approved |
9 | 000000469999 | Approved |
6 | 000000472069 | Approved |
10 | 000000475207 | Approved |
23 | 000000474698 | Approved |
18 | 000000470606 | Rejected |
21 | 000000469609 | Rejected |
18 | 000000469612 | Approved |
15 | 000000474653 | Approved |
9 | 000000472887 | Approved |
4 | 000000473096 | Approved |
6 | 000000473058 | Approved |
3 | 000000473073 | Approved |
25 | 000000473323 | Rejected |
13 | 000000473091 | Approved |
14 | 000000471286 | Approved |
16 | 000000473117 | Approved |
14 | 000000469737 | Approved |
15 | 000000471812 | Approved |
13 | 000000472635 | Approved |
19 | 000000475000 | Approved |
23 | 000000474541 | Approved |
13 | 000000472207 | Approved |
3 | 000000472089 | Approved |
19 | 000000475121 | Approved |
2 | 000000469853 | Rejected |
4 | 000000474352 | Approved |
11 | 000000474329 | Approved |
3 | 000000472932 | Approved |
9 | 000000472932 | Approved |
25 | 000000478565 | Approved |
11 | 000000479064 | Approved |
3 | 000000476096 | Approved |
23 | 000000479089 | Approved |
5 | 000000478283 | Approved |
16 | 000000479127 | Approved |
23 | 000000477135 | Rejected |
9 | 000000477980 | Approved |
3 | 000000482568 | Approved |
4 | 000000482671 | Approved |
5 | 000000482303 | Rejected |
6 | 000000482308 | Approved |
7 | 000000482715 | Approved |
1 | 000000476102 | Rejected |
15 | 000000481802 | Approved |
2 | 000000478762 | Rejected |
7 | 000000480758 | Approved |
3 | 000000482517 | Approved |
10 | 000000480877 | Approved |
21 | 000000478226 | Approved |
Solved! Go to Solution.
Hi @dcg38524 ,
You can create a measure like the following:
percentageof rejections = CALCULATE ( COUNTA ( 'Table'[RESULTS] ), FILTER ( 'Table', 'Table'[RESULTS] = "Rejected" ) ) / COUNTA ( 'Table'[RESULTS] )
Results are as follows:
Here is a demo, please try it:
Best Regards,
Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @dcg38524 ,
You can select the corresponding measure and change the Demical places to 0 in Modeling - Formatting. The result is as follows:
Best Regards,
Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @dcg38524 ,
You can create a measure like the following:
percentageof rejections = CALCULATE ( COUNTA ( 'Table'[RESULTS] ), FILTER ( 'Table', 'Table'[RESULTS] = "Rejected" ) ) / COUNTA ( 'Table'[RESULTS] )
Results are as follows:
Here is a demo, please try it:
Best Regards,
Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
_ Joey, Thank you - your solution worked great;
Question the results are being illustrated as a decimal so I added "* 100" to the end of your DAX measure. How would I format the result to repersent a % with no decimal point?
Thanks again,
Don
NOTE: This Percentage measure is being used as a line within a Stack Column
Hi @dcg38524 ,
You can select the corresponding measure and change the Demical places to 0 in Modeling - Formatting. The result is as follows:
Best Regards,
Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Joey,
Excellent - works as you stated, thank you so much.
Best regards,
Don
Hello-
This should do it:
Rejections = calculate(sum(TABLE NAME[RESULTS]),filter(TABLE NAME, TABLE NAME[RESULTS] = "Rejected"))/calculate(distinctcount(WEEK))
Jared
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |