Need help with formula

[Anonymous]

Hi,

I am trying to compare each value of col1 and col2 , then display the total count of col1 where the values of col1 is greater than

col2, Kidly help me with the formula for this operation

Col1	Col2
244.73	174.81
157.17	0
274.21	195.87
220.93	157.8
95.45	0
87.47	87.47
204.01	145.72
328.18	126.22
135.98	97.13
93.23	77.69
209.17	130.73
86.54	61.81

Thanks,

Ravi

[Phil_Seamark · Accepted solution]

Hi there, try adding a calcuated measure with the following formula.  I have assumed your table is called Table2 (please change)

MyMeasure = CALCULATE(
			COUNTROWS('Table2'),
			FILTER(
				'Table2',
				'Table2'[Col1] > 'Table2'[Col2]
				)
			)

[Anonymous]

Thanks Phil, it works!