Tag: TOPN and CALCULATE

When To Use TOPN In Power BI – A DAX Formula Review

This tutorial will review how to use TOPN as a virtual ranking function to generate interesting insights based on ranking logic in Power BI. You may watch the full video of this tutorial at the bottom of this blog. Using TOPN as a virtual ranking function allows you to dynamically produce the top and bottom

Continue reading

Dynamic Segmentation With Dynamic Parameters – Advanced Power BI & DAX Technique

Dynamic Segmentation With Dynamic Parameters - Advanced Power BI & DAX Technique

I’m going to talk about dynamic segmentation using dynamic parameters because I’ve seen members ask about it so many times on the Enterprise DNA support forum. You may watch the full video of this tutorial at the bottom of this blog. What’s challenging about this is figuring out which areas to segment first. You would

Continue reading

First Purchase of Customer Insight Using DAX

I have another really unique insight to show to you in Power BI. After this session, you’ll be able to identify a customer’s first purchase and use this data to boost your future sales. You may watch the full video of this tutorial at the bottom of this blog. By analyzing a trend in terms

Continue reading

Find Your Top Products For Each Region in Power BI Using DAX

If you are a business selling products in many different stores or across many different regions, then you will want to understand if there is any commonality in your top or bottom selling products. You would want to discover your top products per region. You may watch the full video of this tutorial at the

Continue reading

Ranking Insights Using TOPN In Power BI

In this article, we will explore how we can use the TOPN function in Power BI. You will really enjoy seeing the immense amount of ways that you can utilize this function. You may watch the full video of this tutorial at the bottom of this blog. TOPN is such a powerful function and there

Continue reading