How to use VALUES DAX function and how its DIFFERENT from the DISTINCT DAX Function // Power BI

In this video were going to look at the VALUES DAX function, how to use it, and two key differences it has with the DISTINCT DAX function.
🕓 TIMESTAMPS
0:00 - Intro
00:46 - VALUES
05:31 - DISTINCT
06:13 - Difference in Tables
07:25 - Missing Values
-
📣 Get Demo Files HERE
bit.ly/3dJE2O7
🔍 Looking to get started in data? Check out this COURSE to get the essential skills you need. No experience required.
solutionsabroad.thinkific.com/
📰 Sign up to our FREE Weekly Newsletter for Power BI news, community updates and more
solutionsabroad.co.uk/newsletter
🛒 Power BI TEMPLATES and more at our digital shop
solutionsabroad.co.uk/store
ko-fi.com/solutionsabroad/shop
❤ Other ways to SUPPORT us
/ solutionsabroad
ko-fi.com/solutionsabroad
📧 GET IN TOUCH
Website: solutionsabroad.co.uk/
Email: [e-mail]
LinkedIn: / solutionsabroad
Facebook: / solutionsabroad
Instagram: / solutions_abroad
🤝 SOLUTIONS ABROAD
Hi Power BI fans, my name is Fernan. In 2018 I founded Solutions Abroad to help fellow data enthusiasts learn Microsoft’s tool, Power BI. I’m currently based in London with over 8 years of experience working with data and business intelligence. In this channel I provide educational videos about Power BI including tips and tricks, step by step tutorials, news, and all of it for FREE. I also provide some paid content such as courses, templates as well as consultancy services.
If you like what we’re doing here and would like to support, consider purchasing something or donating through our Patreon, every little penny helps us keep the channel going.
🙏 THANK YOU
Thank you so much for checking out my channel and my videos. You, the community, have been instrumental in growing the channel to where it is now. Hope to see you again on my next video!
#PowerBI #DataAnalytics #BusinessIntelligence

[@dibakarroy3853]

Great work, Fernan. Very insightful. Thank for your perseverance to go deep into in core and bring the differences. I am sure, many seasoned DAX veterans may not be knowing these subtle nuances

[@akinwunmizainab6070]

Hi Fernan,
The demo is for paid members alone. Kindly let us know so we can be informed.
I also found out that the basic knowledge videos as well don't have the link to the data like you stated in the video

[@attilagubacsi9885]

Hi Fernan,
I'm not sure if anybody already noted, but you might need to check on the sound volume setting during your video recordings. I find it way below the average .

[@ExcelWithChris]

Please please help. Somewhere I saw you can get a result in a step, then export that result to another query, come back to this query and ref the step before "exporting" and carry on with the current query.

[@mohsinmanzoor2483]

Hey ,
I want to understand here, If you have used measure on categories itself , like countrows(Distinct(categories[Categoriesname])) and countrows(values(categories[Categoriesname])), and in the table visual you are also using categroiesname from categories table, how come blank value comes in the table visual if there is no blank in categories table itself, Does it use concept of extendedtable, how does it populate blank value?
Please help me in understanding this!

[@dibakarroy3853]

Fernan, the demo file is for paid members only. It is better you make it explicit in your comment so as people can informed decision