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.

vendor analysis

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.

vendor analysis

Bring it in the chart and you’ll have another insightful visualization.

***** Related Links *****
Inventory Management Reports To Show Trends In Sales

Procurement Decisions Model And Analysis In Power BI
Inventory Management Insights With Power BI: Comparing Stock To Sales


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,


Enterprise DNA Power BI On-Demand

The Latest

If you’ve been working with Python for data analysis or machine learning, you’ve likely come across NumPy arrays. They’re a powerful tool for handling numerical data, but sometimes, the data…

How to normalize a numpy array a quick guide.

Multiplying lists in Python is a common operation when performing mathematical computations or solving problems in data manipulation. There are multiple ways to achieve this task, depending on your requirements…

How to Multiply Lists in Python: A Simplified Guide

If you’ve been wrestling with Python lists and wondering how you can save them as a neat CSV file, you’re in the right place. One of the most common tasks…

How to Write a List to CSV in Python

Do you need to write an essay on the fall of the roman empire with accurate citations but have no time to find them? Are you tired of painfully having…

What is Caktus AI: A comprehensive overview

Pandas is a widely used Python library for data manipulation and analysis. One essential functionality that pandas can provide you is the ability to modify the structure of a dataset….

Pandas Drop Index: Efficiently Remove DataFrame Rows or Columns

Working with strings is a common task in Python. You often need to figure out whether a string contains another string. The simplest methods to check if a Python string…

7 Ways to Check if a Python String Contains Another

Ever found yourself knee-deep in Python files, struggling to import a module from a parent directory? If so, you’re in good company. Python’s import system can sometimes feel like a…

Python Import from Parent Directory: A Quick Guide

Data is the backbone of businesses these days, and having proof that you know how to handle and make the most out of data is a big deal in the…

Microsoft DP-500

In programming, you may encounter situations where a variable does not have a value. These instances are commonly represented by a special value known as null. Many programming languages, such…

Null Python: 7 Use Cases With Code Examples

Truncating a floating-point number in Python is a common operation that many programmers encounter in various applications. The process involves removing the decimal place of a float, leaving only the…

Python Truncate Flow: A Streamlined Approach for Efficient Code Execution

OpenAI’s ChatGPT tool has taken the world by storm and has been at the forefront of revolutionizing the way we generate content, do research, and even create code. And just…

Is ChatGPT worth it, let's work it out.

As you continue your journey as a Python programmer, you’ll want to write code that is more efficient, readable, and easy to maintain. The Python programming language comes with a…

Python Inline If: Simplify Your Conditional Expressions

Load More