Calculation help

[pouletbete]

My table (called Responses) is set up like this:

Question Category	Question Number	Total	Points
A	Q1	17	5
A	Q2	4	4
A	Q3	5	1
B	Q1	1	3
B	Q2	0	2
B	Q3	2	1

I have 1 measure called Raw Score

Raw Score =
DIVIDE (
    SUM ( 'Responses'[Points] ),
    SUM ( 'Responses'[Total] )
)

Then my next measure is Composite Score

Composite Score = DIVIDE((([Raw Score]-1)*100),3))

I have a visualization like this:

The thing I want to do is Average these two numbers together. In other words: (66.3+55.1)/2  I only want to average together the Composite Scores of Q3 and Q4.

[Greg_Deckler]

@pouletbete So generally would would do something along the lines like:

Measure = AVERAGEX( DISTINCT( 'Table'[Question] ), [composite score] )

Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[pouletbete]

@Greg_Deckler   Thanks and sorry it is my first time and I'm a Power BI/Dax beginner. I have edited the post to try and make it more clear.

[Greg_Deckler · Accepted solution]

@pouletbete That would seem to be:

Average Measure = 
  VAR __Result = 
    AVERAGEX(
      DISTINCT(
        SELECTCOLUMNS(
          FILTER(
            'Table', [Question Number] IN { "Q3", "Q4 }
          ),
          "__Score", [Composite Score]
        )
       ),
       [__Score]
     )
RETURN
  __Result