Using measure value as compare value

[SylwekGr]

HI, I need your help

In brief I have table:

In Report view I have filtered table by "class" with Average score for filteres values

How can I get "second average score" depends on value greater than "Average Score" as Minimum value for filtered table.

Example:

Rows left that match to "Avererage Score" as Minimum value:

name      | score     | age  | class

------------------------------------

Eva          | 35          | 20    | a

------------------------------------

Jan          | 20          | 20    | a

------------------------------------

Michael   | 20          | 29    | a

Result for "Second Average Score" will be 25

[AlB · Accepted solution]

Hi @SylwekGr 

Average Score 2 =
VAR Ref_ = [Average score]  // The measure you currently have
RETURN
    AVERAGEX ( FILTER ( 'Table', 'Table'[Score] > Ref_ ), 'Table'[Score] )

Please mark the question solved when done and consider giving kudos if posts are helpful.

Cheers  

[jdbuchanan71 · Accepted solution]

Hello @SylwekGr 

This gave me the expected result.

Average above Average = 
VAR _Avg = CALCULATE ( [Average Score], ALLSELECTED ( 'Table' ) )
RETURN
AVERAGEX(
    FILTER ( VALUES ( 'Table'[name] ), [Average Score] > _Avg ),[Average Score] )

[AlB · Accepted solution]

Hi @SylwekGr 

Average Score 2 =
VAR Ref_ = [Average score]  // The measure you currently have
RETURN
    AVERAGEX ( FILTER ( 'Table', 'Table'[Score] > Ref_ ), 'Table'[Score] )

Please mark the question solved when done and consider giving kudos if posts are helpful.

Cheers  

[SylwekGr]

Hi @AlB @jdbuchanan71 

Both solutions works perfect 🙂

thx for quick reply