Need help to show Category + sub category overall average

[Jit007]

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.

[Jit007]

@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

QQ	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%

[Jit007]

 

@gmsamborn Details already provided..Please check..Thanks

[gmsamborn]

Hi  @Jit007 

I have a couple of questions (for now):

• Do you need [Q1 Score] and [Q2 Score] calculated?
  • Why do [Q2 Scores] that “pass” result in 10 instead of 15 like [Q1 Score]?
• How do you calculate [Total Checked] and [Total Met]?

[Jit007]

Share the detailed on this.. Please have a look & let me know incase requier any further details

[gmsamborn]

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.

[Jit007]

@Ashish_Mathur Please suggest. Thanks in advance. 

[Ashish_Mathur]

Cannot understand a thing there.