Count not counting cell values ending in 3 or 6

[Zach373]

Hi all,

So I'm setting up a simple dashboard for my own uses, and i've run into something odd, i'm trying to run a count of a column and the card is returning an incorrect count, when i added a matrix visual to the page to see what was being counted vs. what was missing the only values missing from the count were the ones that end in 3 and 6, in this case DH-63, DH-66 & DH 73. the other odd thing is when i run a count on another column with the same slicers etc. it gives me a count of 17, which is one higher than what is in the actual data, it should be 16 rows of data based on the slicers. There are multiple sheets in the excel book, however this is all based on one sheet in the set, e.g. i'm slicing and running counts off of the same sheet.  i've double checked for typo errors in the data and i've filtered it down in excel and come up with the correct count several times with different counts, the one i'm posting here is just the smallest set so easiest to deal with.

Thank you in advance for any help!

[Zach373]

UPDATE:

so i copied all the data over to a new excel file and started a fresh pbi (after updating pbi) and it seems to be functioning normally. i assume there was something wrong with my initial data or something funky happened with the pbi file that was fixed in the update. either way, i've got a way forward that is showing correct data when sliced.

[Zach373]

Hi, so there is no code that i input, i literally just dropped a card visual and asked it to count for the count of hunt id and count of duck/goose. for the hunt count the code i used is

Hunt Count = COUNTROWS(hunts)

as a measure, but only after i noticed the cards were off, and it's showing the same issue.

the excel sheet is just one i copied and pasted to in order to show what should be showing. i had

the excel sheet filtered to show what the slicers should be showing in pbi. here is a different view,

looks like it's not excluding the same numbers this time, but it is cut down to less than half of what

should be showing. the correct number of records/rows it should be showing is 34.

[danextian]

COUNTROWS() should just count the number of rows based on the current filter context. Whatever the total rows where Hunter  = Zach and Season = 22-23 should be what should appear unless there are other filters at play. Have you check if you have an active visual/page-level/report filter that could be filtering out the other items? Otherwise, can you post a link to your pbix in a cloud storage?

[Zach373]

I created this pbi just last night, well loaded the data into a fresh report anyway. i did double check to make sure there were no page/report level filters and there definitely aren't. As for cloud storage links for it, well, this may sound paranoid but i'm not letting my hunting info get out there, too much competition as it is lol. if there is a way do email me directly via this community or something i'd be happy to let you have a look though.

[Zach373]

EDIT: i did notice that row 15 had a typo, it has been fixed and no change in pbi after refreshing the data

[danextian]

I noticed that  typo but that didn't seem to be the cause. What is your formula? How many rows does data view show?

[danextian]

Hi @Zach373 ,

If it is a simpe count, it should be excluding anything but it is hard to figure out without the actual formula itself. Also, have you checked in the data view if you have indeed just 16 rows. You might have imported 17 because  row 18 in your excel file is a row with invisible characters.

[Zach373]

sorry must have missed the direct reply button, but i did reply above. thanks for taking a look btw!