Forum Discussion

JolienR's avatar
JolienR
Icon for Helper II rankHelper II
4 years ago

COUNTX not counting all values

Hi,

COUNTX is for some reason not counting all "terugkomend" and I have no idea why. Hopefully someone can help me. 

All the columns are measures, except ID_CUSTOMER_GUID. When I select one of the values of the ID's which is not counted and pace it in filters on this visual ID_CUSTOMER_GUID I can not find this ID. However, when I take a look in the table view, I am table to find it. 

 

Need Help

1 Reply

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    4 years ago

    JolienR Perhaps you have some trailing white space in some of your values. Try performing a Trim operation in Power Query for that column.