Forum Discussion
Measure to count rows based on if values are >= x in a column.
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
Try to change the data type of your column to number
Make sure, that the Active column is of type "Number". Then it will work.
9 Replies
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.
Make sure, that the Active column is of type "Number". Then it will work.
Please try the following
Over 10 Days = CALCULATE(COUNTROWS('All_apps'), 'All_apps'[Active] >= 10)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.
Try to change the data type of your column to number
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.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!
