Power BI Practice Intro ROUND #2 I MEASURES vs CALCULATED COLUMNS and CUSTOM TOOLTIPS in Power BI

In this second Power BI Practice Round we are going to assess to what extent a company is dependent on just one single supplier for its products. You need to solve this challenge in two ways - one time using measures and the second time with a calculated columns and custom tooltip in Power BI. Share the solution with us and the community to get feedback.

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.

--------------------------------
📊 TRAININGS 📊
---------------------------------

---------------------------------
😍 JOIN 😍
----------------------------------

---------------------------------
👇 CHECK THIS OUT! 👇
---------------------------------

* 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

[paolaggl]

Thank you much!! Your series of "rounds" have helped me much!

[jitenpatel]

Hello Bas ... I am going to try these Practice exercises for writing measures. My measure writing skills are non-existent. 

On a related but a different note I have a problem that definitely needs your expert guidance. 
I have product types that have a common set of attributes, and where some product types also have additional attributes that varies by product type. 
For the attributes that varies by product type, I have been trying to show just the ones specific to a given product type. 
I have tried using unpivoting using matrix table and cannot get the "Values" section in the Matrix table to show all of the info and not just first or last. 
I have tried using a table visual and getting nowhere.
I am in dire neeed of your expert guidance.
Thank you in advance
jiten