DAX Fridays! #71: Optimize a DAX measure

In today’s video I will show you how to create a bit more complex calculation using DAX. We will calculate the average number of categories per customers.

In Part one, we will calculate it using Summarize, and then summarize and addcolumns and finally, summarize and addcolumns and calculate to get the right totals.:
   • DAX Fridays! #69: How to write a DAX ...  

In part 2 (   • DAX Fridays! #70: How to write a DAX ...  ): we will use AverageX only and

In part 3 (lthis video): we will remove the bi-directional relationship and calculate it without it.

PREVIOUS VIDEO:
NEXT VIDEO:


Looking for a download file? Go to our Download Center: https://curbal.com/donwload-center

SUBSCRIBE to learn more about Power and Excel BI!
   / @curbalen  

Our PLAYLISTS:
Join our DAX Fridays! Series: https://goo.gl/FtUWUX
Power BI dashboards for beginners: https://goo.gl/9YzyDP
Power BI Tips & Tricks: https://goo.gl/H6kUbP
Power Bi and Google Analytics: https://goo.gl/ZNsY8l

ABOUT CURBAL:
Website: http://www.curbal.com
Contact us: http://www.curbal.com/contact

************



************


QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
► Twitter: @curbalen, @ruthpozuelo
► Google +: https://goo.gl/rvIBDP
► Facebook: https://goo.gl/bME2sB

#daxfridays #curbal #SUBSCRIBE
► Linkedin: https://goo.gl/3VW6Ky