Values x Distinct

As the lecture here says ( (and microsoft documentation too), the difference btw values and distinct is that one shows blank values, while the other does not.

However, look at this:


Can someone plz explain?

Thanks =)

you likely have " " space in your data which isn’t classify as a null which is your cell is completely blank.

I would check your data for that

I hope that helps.

1 Like

Bumping this post for more visibility from our experts and users.

Hi @klein.keagan,

Due to inactivity, we’d like to conclude that your inquiry was out of the experts’ and users’ bounds.

If you were sure you provided all pertinent context to your concerns and read how to use the forum more effectively and still find your question unanswered, your membership also comes with relevant resources that may help you with your Power BI education, so we advise that you check these resources as well.

While our users and experts do as much as reasonable to help you with your inquiries, not all concerns can be attended to especially if there are some learnings to be done. Thank you!