topic Re: ALLNOBLANK confusion - please help in DAX Commands and Tips

ALLNOBLANK confusion - please help

music43 — Thu, 14 Nov 2024 09:24:33 GMT

Hi

Have I completely missed the point of this function or is there something going on here that I just don't grasp?

Thanks in advance.

Oli

Re: ALLNOBLANK confusion - please help

johnt75 — Thu, 14 Nov 2024 10:09:57 GMT

It is confusing. ALLNOBLANKROW only filters out blank values if they have been automatically added to create a valid relationship. If the blank values exist in the underlying data then they will still be returned.

To make sure that blank values are not returned use DISTINCT instead.

Re: ALLNOBLANK confusion - please help

music43 — Thu, 14 Nov 2024 10:45:50 GMT

Thank you for the clarification!

I hope you have a good day.