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: