Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Need help with formula

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

 

 

Col1Col2    
244.73174.81
157.170
274.21195.87
220.93157.8
95.450
87.4787.47
204.01145.72
328.18126.22
135.9897.13
93.2377.69
209.17130.73
86.5461.81

 

Thanks,

Ravi

Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    9 years ago

    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]
				)
			)

     

2 Replies

  • Phil_Seamark's avatar
    Phil_Seamark
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    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's avatar
      Anonymous
      Not applicable
      9 years ago

      Thanks Phil, it works!