Power BI & DAX: HASONEVALUE() vs. HASONEFILTER()

The title is pretty self-explanatory, the two Power BI DAX titans are going to collide in this video. Two functions enter the arena but only one will leave…

Well, obviously, I am only kidding… The two functions have drastically different purposes and objectives and by the end of the video you will have all the background you need to know when to use one vs. the other. 

Also, I demonstrate how a type of relationship (Single vs. Both) can break a measure that otherwise seems super rock solid, so if you get yourself in situations when Power BI seems broken and your measure just does not seem to cooperate even though the DAX looks to be perfect, then you have yet another reason to watch the video below:

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s