Count and Countrows returning the wrong figure

[adriansuteu]

Hi.

I have a table that contains ~2900 rows with columns. You can see it in the screenshot below.

I am trying to count the orders (each order has a row in this table) and create visualizations based on the figures.

The problem is that the formulas return strange values:

Measure = countrows('Orders') returns 50

Measure = count('Orders'['Count']) returns 50 (after creating the column Count=1)

Measure = calculate(countrows('Initial Orders'),all('initial orders'))  returns the right number, but then if I add Axis (categories of products) I get the same figure for each value.

Please help me figure this out.

Thanks.

[Anonymous]

I faced the same issue.

I have country names in a column and I need to count the number of times they appear.

I used the following DAX to count the number of times they appear in the table -:

Matches Won = COUNT('Cricket Data'[Winner])

But, it gave me a terrible result when I put it against the country names. It actually gave me the number of times they appear in "Country" column rather than giving it from the "Winner" column.

I think its a bug.

Please fix this ASAP.

[v-shex-msft]

Hi @adriansuteu,

Can you share the sample file to test? I can't find the columns which you used in the formula.

In addition, can you provide some detail content of your opertions? It will be help for troubleshooting.

Regards,
Xiaoxin Sheng

[adriansuteu · Accepted solution]

Hi.

I solved the problem.

I guess it was some kind of bug.

All I did was to copy the source data (the whole table as it is), from a multiple sheet xlsx to a csv file and then use that file as source. And now everything works fine, COUNT, COUNTA and COUNTROWS.

Thanks for your interest!

[Anonymous]

Even if I run the same formula by changing the data source to csv... The error remains as it was before...

[Vvelarde]

@adriansuteu

Hi, Are you applied some kind of filter or slicer in your page?