Power BI Practice Solution ROUND #2 I MEASURES vs CALCULATED COLUMNS and CUSTOM TOOLTIPS in Power BI
In this second Power BI Practice Round we are assessing to what extent a company is dependent on just one single supplier for its products. We solve this challenge in two ways - one time using measures and the second time with a calculated columns and custom tooltips in Power BI.
Requirements:
Key Visuals:
- Create a measure that returns the number of Vendors per product.
- Create one measure that calculates the number of products with 1 Vendor.
- Add another measure that calculates the number of products with more than 1 Vendor.
- Show it share 1 Vendor vs more than 1 Vendor on a donut chart.
- Try to get to a similar visualisation but now by adding a calculated column. The calculated column should calculated the number of vendors for each product and either return more than 1 Vendor or 1 Vendor.
- Show it share 1 Vendor vs more than 1 Vendor on a donut chart.
Download file here https://datatraining.io/powerbi-how-to
--------------------------------
📊 TRAININGS 📊
---------------------------------
Power BI Design 4 Weeks Transformation Program https://my.datatraining.io/pages/powe...
Power BI Essentials https://datatraining.io/powerbilearni...
Business User Training https://datatraining.io/powerbi-busin...
For Custom Trainings and Consulting email directly [email protected]
---------------------------------
😍 JOIN 😍
----------------------------------
Join https://bit.ly/4b453bi
Subscribe https://bit.ly/31MnQGO
Insta / howtopowerbi
LinkedIn / basdohmen
TikTok / how.to.power.bi
X / howtopowerbi
fb / howtopowerbi
Threads https://www.threads.net/@howtopowerbi
Newsletter https://datatraining.io/newsletter
---------------------------------
👇 CHECK THIS OUT! 👇
---------------------------------
💻 My gear https://amzn.to/47F21Yc
📚 Power BI books MUST READ! https://amzn.to/3tUfFcj
💡 General books I recommend https://amzn.to/48YNo33
🎶 Music for my videos https://www.epidemicsound.com/referra...
🚀 For growing on YouTube: https://www.tubebuddy.com/bas
🏄 Stuff I use daily https://amzn.to/3HqfMQ2
* Above are affiliate links, which means at no additional cost to you, if you make a purchase using these links we will receive a small commission. It supports us and helps us to continue making more How to Power BI videos!
Thanks for being a part of this channel and all your support! 💪 🙏
#HowToPowerBI #PowerBI #DataTraining
#powerbidesktop #powerbitraining #powerbideveloper #DAX
Watch video Power BI Practice Solution ROUND #2 I MEASURES vs CALCULATED COLUMNS and CUSTOM TOOLTIPS in Power BI online without registration, duration hours minute second in high quality. This video was added by user How to Power BI 31 August 2020, don't forget to share it with your friends and acquaintances, it has been viewed on our site 7,490 once and liked it 181 people.