Countrows based on number

[rosscortb]

Hello,

I have the following formula that works but the result is wrong

Total Blue Collar = COUNTROWS(FILTER('DB Headcount','DB Headcount'[Cost Center Number] = 100000))

Cost Center Number is a whole number not text so how do I count the rows based on this numerical value please?

Thanks

Ross

[dax · Accepted solution]

Hi rosscortb,

According to your description, you seems to count rows which number is 100000 in table, right? This should work(if it is text, you need to write like below="100000"). What is your problem or error information? If possible, could you please inform me in details(your sample data and your expecting output)? Then I will help you more correctly.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[KHorseman]

Can you explain what is wrong about the results you're getting? What result do you expect and what result are you getting?

[rosscortb]

Hi,

It produces a result that is 1000 more than the answer

Thanks

Ross

[parry2k]

@rosscortb how you are comparing that it is giving 1000 more than answer? Can you take smaller dataset to see if that works and go from there. 

[KHorseman]

Can you give any other details about the data model? Are there other things filtering the data? Are you expectnig a count of all separate rows with that Cost Center Number or just a count of some particular member of the table? What kind of data is on this table? There simply aren't enough details here to guess what the problem could be.