DAX Fridays 12 SUM of distinct values
>> YOUR LINK HERE: ___ http://youtube.com/watch?v=0AeEpjYrwG0
PREVIOUS VIDEO: • DAX Fridays! #11: Using variables in DAX • NEXT VIDEO: - • Have you ever tried to calculate the sum of distinct or unique values in Power BI? Not straight forward right? • A distinct sum is a sum where you specify the values that you want to have included in the totals. W • In this video tutorial we will go through the wrong and the right way(s) to do it. • Link to SUMX video: • DAX Fridays! #3: SUM and SUMX • Link to sample pbix: https://goo.gl/pxq7cf • Chapters: • 00:00 Intro • 03:37 SUMX Calculation • 06:00 Distinct sum with MAX as part of the expression • 08:00 Distinct sum with MAX as a measure • Done! • • 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
#############################
