Avoiding circular dependency errors in DAX

[danielsiffredi]

you are not only a PBI master, you are a mind reader as well . I had to get some work done and was hitting exactly the circular dependency scenario when creating a bridge table - this technique saved me tons of hours of research - THANK YOU !!! Grazie caro!!!!

[danmeiss]

So not only are the SQLBI guys putting out great content, but now they are also mastering the art of the YouTube thumbnail image 😀. Love the expression Alberto. Keep up the good work, we all benefit from it!

[sbn]

Excellent. I'm beginer DAX and I red from your book about it, it was very clearly but waching with vidio is a big pleasure. Thank you Mr Alberto

[carlottasudbury]

Words cannot express how helpful this was. I was just about to give up until I found this.

[vini_sepol]

Thank you so much for your explanation! You've helped me a lot. I was stuck on this circular dependency problem and your video was the only one that really helped me to solve it. From now on I'll make sure to properly set the "ALLEXCEPT" in all my "CALCULATE" functions. Keep doing your videos. Excellent content! Many thanks from Brazil (:

[mnowako]

Excellent. I’m just wondering if you know how good your videos are for everyone who is eager to learn DAX? Thank you Alberto!

[sanketkulkarni]

Amazing !! you wonderfully explained how to avoid Circular dependency, this helped me in many cases and to understand how Power BI deals with it in backend. Thanks a lot for the help !! :)

[jonathanVA]

Thank you so much for this. Just to help you in your English grammar since you helped me in my DAX, after "did" you need to put everything in past tense, so "is" becomes "was" and you also need to turn the gerund "creating" into the verb "to create." So instead of "What I did is creating a table" one says, "What I did was to create a table"

[gregoryoliveira]

Thanks a lot for sharing this with us! I struggled to understand why my calculate table was not accepting the relationship. Now I understood. Thanks again!

[pilarbaldominos]

Fantastic video...I have been struggling with this issue long enough!

[sergiocaptuleio]

Show!!!!
Being able to resolve an addiction by watching this video. Thanks!!!

[sibinmathewjose]

You are awesome! I was working for this issue for so long! Thanks alot!

[stephencross]

This video is a lifesaver, thank you so much!! Been Battling this issue for days and you helped me understand and solve my problem ;-)

[PedroHenrique-bpts]

Love you, buddy. Always helping me out

[gonqq]

This video was a life saver, thank you so much and keep it going, you're a master!

[praveenkumar_]

Thank you for the video, really helped understanding why this kind of errors occurs.

[Bharath_PBI]

Hi, So breaking circular dependency this way will not break data lineage.
Thank you 👍

[manasac]

Amazing! this solved my issue in 10seconds. Thanks for the video

[MartinCollazos]

You are convencing me to take the dax course ...

[supersayan]

Amazing! I was struggling with this. I could not solve it, so I turned to SQL.
Now I know. 😀

Just curious if you would use calculated table, whether that would be faster than using the filter function.