How to calculate a measure based on another measure.

[saikrish_01]

Hi.

 I have a table like the below.

Class	Section	Students	Marks
1	A	Nick	87
1	A	Jones	83
1	A	Smith	80
1	B	Will	92
1	B	Smith	90
1	B	Rock	65
1	C	James	50
1	C	Anderson	65
1	C	Walker	79
2	A	Paul	56
2	A	Peter	32
2	A	Parker	95
2	B	Grame	81
2	B	Smith	87
2	B	Walter	72
2	C	White	67
2	C	Jesse	54
2	C	Pinkman	11

I used a simple average measure to calculate the average of each section in all classes.

I need to create another measure which counts the number of sections in a class having average more than 60.

I hope my doubt is clear.

Kindly help me with the DAX Measure for the above.

Thanks 🙂

[saikrish_01]

Thanks so much for helping me out. it worked !!!! 🙂

[some_bih · Accepted solution]

Hi @saikrish_01 ,

I insert your data into Excel; Sheet3 name you should adjust according your names. I hope this help

Avg measure: 

Ave Se =

AVERAGEX ( Sheet3, [Marks] )
Second measure:

# Sect higher 60 =

VAR _value=60

VAR _sectionswithAvg=

    ADDCOLUMNS(SUMMARIZE(

        Sheet3,

        Sheet3[Class],

        Sheet3[Section]),

        "@AvgSec", [Ave Se]

    )

VAR _fitlered_table=

    FILTER(

        _sectionswithAvg,

        [@AvgSec]>_value

    )

RETURN

--number of section above threshold

COUNTROWS(_fitlered_table)