COunt rows or get value of specific column

[srikumarv]

Hi,

I was trying to see how could get count of rows or the value of index column i have created for table. I have cummulative percentage column and i want to get count of row or index column value for the condition where cumulative percentage is less than or equal to 75%

     

Based on above data i want to get the value of index column or the count of rows for cumulative percentage (CUM_PT%) less than  75.0% . I have tried countrows and it always gives me the total number of rows

NumberOfBrokers = CALCULATE(COUNTROWS(BROKER_GROUP_INFO),BROKER_GROUP_INFO[CUM_PT%]<=75.0)

Appreciate any guidance.

[DoubleJ · Accepted solution]

Hi 

Your formula looks good. I think the CUM_PT% colum is formatted to be displayed in percentage. The real value for the first row (11.6%) probably is 0.116. Therefore 75% would be 0.75. So, change your formula from 75 to 0.75 and you should be ready to go.

I hope my assumptions are correct.

JJ

[Vvelarde · Accepted solution]

@srikumarv

hi, Cum_pt% is percentage so 75% is 0.75

NumberOfBrokers = CALCULATE(COUNTROWS(BROKER_GROUP_INFO),BROKER_GROUP_INFO[CUM_PT%]<=0.75)

[DoubleJ · Accepted solution]

Hi 

Your formula looks good. I think the CUM_PT% colum is formatted to be displayed in percentage. The real value for the first row (11.6%) probably is 0.116. Therefore 75% would be 0.75. So, change your formula from 75 to 0.75 and you should be ready to go.

I hope my assumptions are correct.

JJ