Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
Need help on this below. Thanks
I have data table as below
Yes - Full Score 15
No - Zero Score 00
NA- Not applicable for that scenrio
ID# | Q1A | Q1B | Q1C | Q1D | Q1 Score | Q2A | Q2B | Q2C | Q2 Score |
111 | Yes | Yes | Yes | Yes | 15 | Yes | Yes | Yes | 10 |
111 | Yes | No | No | Yes | 0 | No | Yes | Yes | 0 |
222 | Yes | NA | NA | Yes | 15 | NA | NA | Yes | 10 |
333 | No | No | No | Yes | 0 | Yes | No | NA | 0 |
How to achieve this in Power Bi.
@Ashish_Mathur @gmsamborn Thanks for looking into my query & sorry for sharing Incomplete information earlier.
PFB complete information of my project & need your help to show expected result as shown below.
Please let me know incase require any further details.
Ticket ID# | Agent Name | Q1A | Q1B | Q1 Score | Q2A | Q2B | Q2 Score | Q3A | Q3B | Q3Score | Q4A | Q4B | Q4Score | Q5A | Q5B | Q5Score | Q6A | Q6B | Q6Score | Q7A | Q7B | Q7Score | Q8A | Q8B | Q8Score | Q9A | Q9B | Q9Score | Q10A | Q10B | Q10Score | Overall Score |
111 | AAA | Yes | Yes | 15 | Yes | Yes | 15 | No | Yes | 0 | Yes | Yes | 10 | Yes | Yes | 5 | Yes | Yes | 5 | Yes | Yes | 5 | Yes | Yes | 10 | Yes | Yes | 10 | Yes | Yes | 5 | 80 |
222 | AAA | Yes | Yes | 15 | Yes | Yes | 15 | No | Yes | 0 | Yes | Yes | 10 | Yes | Yes | 5 | Yes | Yes | 5 | Yes | Yes | 5 | Yes | Yes | 10 | Yes | Yes | 10 | Yes | Yes | 5 | 80 |
333 | BBB | Yes | Yes | 15 | Yes | Yes | 15 | Yes | Yes | 20 | Yes | Yes | 10 | Yes | Yes | 5 | Yes | Yes | 5 | Yes | NA | 5 | Yes | Yes | 10 | Yes | Yes | 10 | Yes | Yes | 5 | 100 |
444 | BBB | Yes | Yes | 15 | Yes | Yes | 15 | Yes | Yes | 20 | Yes | Yes | 10 | Yes | Yes | 5 | Yes | Yes | 5 | Yes | Yes | 5 | Yes | Yes | 10 | Yes | Yes | 10 | Yes | NA | 5 | 100 |
555 | CCC | Yes | Yes | 15 | Yes | Yes | 15 | YEs | Yes | 20 | Yes | Yes | 10 | Yes | Yes | 5 | Yes | Yes | 5 | Yes | Yes | 5 | Yes | Yes | 10 | Yes | Yes | 10 | Yes | Yes | 5 | 100 |
666 | CCC | Yes | Yes | 15 | Yes | Yes | 15 | YEs | Yes | 20 | Yes | Yes | 10 | Yes | Yes | 5 | Yes | Yes | 5 | Yes | NA | 5 | Yes | Yes | 10 | Yes | Yes | 10 | Yes | No | 0 | 95 |
Yes | Full Score |
No | Zero Score |
NA | Not Applicable |
Score | |
Q1 | 15 |
Q2 | 15 |
Q3 | 20 |
Q4 | 10 |
Q5 | 5 |
Q6 | 5 |
Q7 | 5 |
Q8 | 10 |
Q9 | 10 |
Q10 | 5 |
Overall Score | 100 |
Expected result in Power Bi Visual
Category | Total Chekced ticket id | Met Expection | Met Expection % | Total deficit |
Q1 | 10 | 7 | 70.0% | |
Q2 | 10 | 5 | 50.0% | |
Q3 | 10 | 5 | 50.0% | |
Q4 | 10 | 6 | 60.0% | |
Q5 | 10 | 4 | 40.0% | |
Q6 | 10 | 8 | 80.0% | |
Q7 | 10 | 10 | 100.0% | |
Q8 | 10 | 9 | 90.0% | |
Q9 | 10 | 10 | 100.0% | |
Q10 | 10 | 7 | 70.0% |
Hi @Jit007
I have a couple of questions (for now):
Share the detailed on this.. Please have a look & let me know incase requier any further details
Hi @Jit007
I'm still waiting for answers to my questions so lets try this...
Can you provide the following?
1) Please provide sample data that covers your issue or question completely.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
2) Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
3) Please explain how you would expect to get from step 1 to 2.
4) If possible, please show your past attempts at a solution.
A .pbix file with sample data would be BEST but all 4 steps are important.
Cannot understand a thing there.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
102 | |
84 | |
79 | |
68 |
User | Count |
---|---|
120 | |
110 | |
94 | |
81 | |
77 |