Measure to count rows based on if values are >= x in a column.

[edjeff82]

I have a table with a column called 'Active', containing values anywhere between 0 and say 20.

I would like to create a card in my dashboard that shows how many rows have a value of 10 or greater in the 'Active' column. I am trying to create a measure for this so I can then populate the measure on a card, but nothing I am trying seems to work.

I have tried

Over 10 Days = COUNTROWS('All_apps'[Active] >9)

and 

Over 10 Days = CALCULATE(COUNTROWS('All_apps'),('All_apps'[Active] > 9))

But neither of these are working. I know there must be a simple solution but I cannot work out what it is!

[MattiaFratello · Accepted solution]

Try to change the data type of your column to number

[edjeff82]

Thanks everybody for your help and suggestion. Still a bit of a noob with PowerBI and had not noticed the data type for my column was not Number!

[v-fenling-msft]

Hi, @edjeff82 

It looks like you have found a solution. Could you please mark this helpful post as “Answered”?

This will help others in the community to easily find a solution if they are experiencing the same problem as you.

Thank you for your cooperation!

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[MattiaFratello]

Please try the following
Over 10 Days = CALCULATE(COUNTROWS('All_apps'), 'All_apps'[Active] >= 10)

[edjeff82]

Thanks, unfortunately when I try this I get the following error;

MdxScript(Model) (42, 66) Calculation error in measure 'All_apps'[Over 10 Days]: DAX comparison operations do not support comparing values of type TEXT with values of type Integer. Consider using the VALUE or FORMAT function to convert one of the values.

[Ashish_Mathur]

Hi,

In the Query Editor, change the data type to number.

[MattiaFratello · Accepted solution]

Try to change the data type of your column to number

[zenisekd]

Hi @edjeff82 ,

How about: Over 10 Days = CALCULATE(COUNTROWS('All_apps'),FILTER('All_apps','All_apps'[Active] > 9))

Make sure, that the Active column is of type "Number". Then it will work. 

[edjeff82]

Thanks, unfortunately when I try this I get the following error;

MdxScript(Model) (42,83) Calculation error in measure 'All_apps'[Over 10 Days]: DAX comparison operations do not support comparing values of type TEXT with values of type Integer. Consider using the VALUE or FORMAT function to convert one of the values.

[zenisekd · Accepted solution]

Make sure, that the Active column is of type "Number". Then it will work.