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.

--------------------------------
📊 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

[famousjamous]

Another great video. When your channel blows up I’ll be able to say “I was there in the beginning!”

[bushehrnoshishi]

I love this series!
I have no real experience with Power BI - I knew that it existed, watched a lot of tutorials, even followed along with one or two, but could never grasp it. Your content especially in this series helped me to remedy this.
Thank you, Bas!

[CJ-jctn]

Terrific video! Thank you for providing extremely useful and perfectly explained content on Power BI. It takes skill to make complicated topics seem easy and you definitely have mastered that skill. I learned so much about context transition today! Thank you Bas!

[raghavendrakumar]

You explain complex topics in a simpler way. Good work and keep going.

[abeerattia]

Thanks for sharing you knowledge with us, i got the result by Power Query and by Grouping by and create a column of Count and got the column i used to distinguish between one vendor or more

[cavanagd]

I love your content man. These practise rounds have great.

[fedaaawad]

Thank you for this series.
what is the difference between "DISTINCT" and "VALUES"?? they brought to me the same results here