# Vendor Analysis In Inventory Management Dashboards

In this tutorial, you’ll learn how to add elements for vendor analysis in your inventory management dashboards using DAX formulas.

Previous blogs have discussed how to set up the data model and the code used to get stock reorder analysis. The next details you need to focus on are the vendor tables.

You have a number of different vendors and you should know how much inventory you have for each of them. Thus, you have narrow down your vendors to the top 5.

This part brings in another concept or pattern that you can utilize in your formulas with DAX. You just need to understand how to utilize it in your models to get valuable insights quickly and effectively.

## Vendors By Stock Units

Create a new measure and name it Top 5 Vendors by Stock Units. Then, use the CALCULATE function and put the Inventory Stock Quantity.

In another line, add in the TOPN function and input 5 to return the top five. Use the ALL function and then order it again using the inventory stock quantity. This ALL statement releases the context on the vendors. So, you need to bring back the content by using the VALUES function.

If you bring it into the chart, it will only show you 5 values. It blanks out everyone that is not in the top five.

## Vendors By Stock Value

Next, copy the previous measure and alter it to get the Top 5 Vendors by Stock Value.

Bring it in the chart and youâ€™ll have another insightful visualization.

## Conclusion

The vendor analysis technique discussed in this tutorial is simple but it can give you insights that add immense value to your inventory management reports.

With the steps you’ve implemented following previous tutorials, your dashboard has now all the insights and logic that you need. The next thing to do is to correctly fix and format all the elements in your report. The next tutorials will cover this lesson.

All the best,

Sam

## How To Compare Two Lists Of Calculated Data Virtually – An Advanced DAX Technique

When working with calculated data, comparing different data sets will sometimes be necessary. I'm going...

## Heat Map – A Great Visualization For Power BI Reports

In this tutorial, youâ€™ll learn how to create a heat map visual using Charticulator. It is used to...

## CALCULATE Function – How It Can Affect Your Calculations On Power BI

In this tutorial, I want to show you what the CALCULATE function can do through a few examples....

## Remove Empty Columns In Power BI

This blog will demonstrate how to automatically remove all empty columns in Power BI through the Power...

## DAX Calculation Groups – Power BI Report for Problem Of The Week #7

I'm going to talk about the solution I came up with for the 7th Problem of the Week. The problem...

## Publishing PowerApps Applications and Changing The Screen Order

In this tutorial, we're going to talk about publishing PowerApps applications and making sure the...

## Power BI Financial Reporting: Allocating Results To Templates At Every Single Row

Here I want to showcase a unique idea around financial reporting, which is allocating results to...

## Optimizing Queries For A Faster DAX Performance

This tutorial will talk about optimizing your queries in DAX Studio. You'll also learn how to mitigate...

## Format Data In Power BI: Addressing Irregular Data Formats

In today's blog post, we'll discuss Problem of the Week #6. I'll show you how to format data in Power...

## Power BI P&L Statements: Challenges And Solutions

Profit and Loss Statements are often challenging to create in Power BI, especially if you're working...

## How To Install DAX Studio & Tabular Editor In Power BI

In this tutorial, you'll learn how to download and install DAX Studio and Tabular Editor 3 in your...