Sum of a measure

[Anonymous]

Hi,

I have data of a production line and calculate the average station time. So I add a measure to calculate it.

Station	Average (Measure)
10	15
20	13
30	14
35	16
40	18
50	16
55	15

Now I want to count the amount of stations where the time is above 15. Therefore I add another measure.

Measure 2 = IF([Average] > 90, 1, 0)

So I get this.

Station	Average (Measure)	Measure 2
10	15	0
20	13	0
30	14	0
35	16	1
40	18	1
50	16	1
55	15	0
Total	107	1

Now I want to create a third measure to build the SUM of the Measure2.

But it doesnt' work. Do someone has an idea to create this measure?

I am a little bit confused because the Total of Measure2 is 1 and not 3...

FYI: I use direct query!! So it isn't possible to add a column!

Best regards

Timo

[Zubair_Muhammad · Accepted solution]

@Anonymous 

Try following

Measure 2 =
SUMX ( VALUES ( TableName[Station] ), IF ( [Average] > 90, 1, 0 ) )