# 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

## Optimizing DAX: Performance Tips for Power BI Reports

Data analysis in Power BI is not only about creating visually appealing reports but also about ensuring...

## DAX Table Functions Deep Dive

Explore an in-depth analysis of DAX table functions in Power BI, comparing SUMMARIZE and ADDCOLUMNS, and understanding INTERSECT and EXCEPT for enhanced data manipulation and analysis.

## Introduction to the RANKX and TOPN DAX functions in Power BI

One of the key aspects of analyzing data is to be able to rank or compare different elements based on...

## Power BI Visualization Technique: Learn How To Create Background Design Plates

Here's a Power BI visualization technique that you can utilize within your reports by using large...

## ALL Function in Power BI – How To Use It With DAX

Did you know that the ALL function can be used to modify the context of a particular calculation in...

## Calculate Average Per Customer Transaction Using DAX In Power BI

What I want to demonstrate in this tutorial is how we can calculate average sales, profits, or...

## Round Bar Chart – A Visualization For Your Dashboard

In this tutorial, you’ll learn how to create round bar charts for your Power BI report. It’s another...

## Conditional Formatting with Transparency Hex Codes

One of the best ways to implement conditional formatting is using the Field value option in the...

## Custom Theming In Power BI

For today's post, I'll do a quick review of the customizations you can make by directly editing and...

## Power BI Automation With Elgato Stream Deck

Today, I'm going to walk you through an outstanding Power BI automation using Elgato Stream Deck. We're...

## How To Create Profit And Loss (P&L) Statements In Power BI

In this tutorial, I’ll be teaching the Profit and Loss, or P&L statement, in Power BI. You may...

## Power BI Project Planning: Discovery & Ingestion

In today's blog post, we'll be continuing our series on how you can plan for your Power BI project....