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 ...
In part 2 ( • DAX Fridays! #70: How ... ): 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: curbal.com/don...
SUBSCRIBE to learn more about Power and Excel BI!
/ @curbalen
Our PLAYLISTS:
Join our DAX Fridays! Series: goo.gl/FtUWUX
Power BI dashboards for beginners: goo.gl/9YzyDP
Power BI Tips & Tricks: goo.gl/H6kUbP
Power Bi and Google Analytics: goo.gl/ZNsY8l
ABOUT CURBAL:
Website: www.curbal.com
Contact us: www.curbal.com/...
************
************
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
► Twitter: @curbalen, @ruthpozuelo
► Google +: goo.gl/rvIBDP
► Facebook: goo.gl/bME2sB
#daxfridays #curbal #SUBSCRIBE
► Linkedin: goo.gl/3VW6Ky