Skip to main content

20 Power BI Dax Measures


UserPower bi 20 dax measures 20 DAX (Data Analysis Expressions) measures in Power BI with examples:

  1. Total Sales:

    scss
    Total Sales = SUM(Sales[Amount])

  2. Average Sales Price:

    scss
    Avg Sales Price = AVERAGE(Sales[Amount])

  3. Total Units Sold:

    mathematica
    Total Units Sold = SUM(Sales[Quantity])

  4. Total Customers:

    scss
    Total Customers = COUNTROWS(Customer)

  5. Total Products:

    mathematica
    Total Products = COUNTROWS(Product)

  6. Maximum Sales Amount:

    scss
    Max Sales Amount = MAX(Sales[Amount])

  7. Minimum Sales Amount:

    scss
    Min Sales Amount = MIN(Sales[Amount])

  8. Sales Growth Percentage:

    mathematica
    Sales Growth % = (Total Sales - [Total Sales Last Year]) / [Total Sales Last Year]

  9. Total Profit:

    scss
    Total Profit = SUM(Sales[Profit])

  10. Total Orders:

    scss
    Total Orders = COUNTROWS(Orders)

  11. Total Customers with Sales:

    css
    Total Customers with Sales = COUNTROWS(FILTER(Customer, [Total Sales] > 0))

  12. Total Sales by Region:

    mathematica
    Total Sales by Region = SUMX(VALUES(Region[RegionName]), [Total Sales])

  13. Total Sales by Year:

    scss
    Total Sales by Year = SUMX(VALUES(Calendar[Year]), [Total Sales])

  14. Running Total Sales:

    scss
    Running Total Sales = SUMX(FILTER(ALL(Calendar), Calendar[Date] <= MAX(Calendar[Date])), [Total Sales])

  15. Top N Products by Sales:

    mathematica
    Top N Products by Sales = TOPN(5, ALL(Product), [Total Sales])

  16. Rolling Average Sales (3 Months):

    scss
    Rolling Avg Sales 3M = AVERAGEX(DATESYTD(Calendar[Date]), [Total Sales])

  17. Total Sales to Date:

    mathematica
    Total Sales to Date = TOTALYTD([Total Sales], Calendar[Date])

  18. Sales Rank by Product:

    mathematica
    Sales Rank by Product = RANKX(ALL(Product), [Total Sales], , DESC, Dense)

  19. Customer Churn Rate:

    css
    Customer Churn Rate = DIVIDE([Lost Customers], [Total Customers])

  20. Year-to-Date Growth:

    mathematica
    YTD Growth = DIVIDE([Total Sales], [Total Sales Last Year]) - 1

These measures cover a range of common calculations in Power BI, including basic aggregations, comparisons, and time-based calculations. You can adapt and customize them to suit your specific data and reporting needs

Labels:

Comments

Post a Comment

Popular posts from this blog

Recover Unsaved Excel File

We normally avoid these settings but in the hour of need they save us rework time. So if your working on a excel file and you forget to save it or click on don't save by mistake, follow below steps  If the workbook was open for at least 10 minutes and created an AutoRecover version, Excel kept a copy for you. Follow these steps to get it back: Open Excel. In the left panel, choose Open Other Workbooks. In the center panel, scroll all the way to the bottom of the recent files. At the very end, click Recover Unsaved Workbooks. Excel shows you all the unsaved workbooks that it has saved for you recently. Click a workbook and choose Open. If it is the wrong one, go back to File, Open and scroll to the bottom of the list. When you find the right file, click the Save As button to save the workbook. Unsaved workbooks are saved for four days before they are automatically deleted. Use AutoRecover Versions to Recover Files Previously Saved Recover Unsaved Workbooks applies only to files that...
Post a Comment
Read more

Pivot Tables and how to use them

Excel pivot tables are very useful and powerful feature of MS Excel. They are be used  to create instant summaries, reports and data analysis from your raw data .  In this page, learn all about how to create an Excel pivot table and customize it. 1. What are Excel Pivot Tables  A pivot table  turns  your data into report format. Here is a sample Pivot table from sales data, showing  total sales by region. 2. How to Create a Pivot Table We will use 2019 sales data of a fictional company. This data contains 466 rows of sales information in columns – Month, Salesman, Region, Product, No.  Customers, Net Sales, Profit / Loss. Here is a preview of our data. To create a pivot table showing  totals sales by region , follow these steps. Select any cell in the data. Go to Insert ribbon and click “Pivot Table” button.  Click ok on the next screen. You will be taken a new spreadsheet with  blank Pivot Table canvas.   Here, using the Pivot...
Post a Comment
Read more

How to create a Waterfall Chart

Download Example Waterfall chart file from below link https://drive.google.com/file/d/17OKYxHKzT8NxWM0FuPqEb26ntzQqa29_/view?usp=sharing How to Create a Waterfall Chart in Excel If you want to build a waterfall chart of your own, we’ve got the step-by-step instructions for you. Although Excel 2016 includes a waterfall chart type within the chart options, if you’re working with any version older than that, you will need to construct the waterfall chart from scratch.  Step 1: Create a data table Let’s start with a simple table like annual sales numbers for the current year. You will see in the table below that the sales amounts vary for each month. Some months will have positive sales growth, while others will be negative.     Insert three additional columns to your Excel table to represent the movement of the columns on the waterfall chart. The base column will represent the starting point for the fall and rise of the chart. You will input all the negative numbers fro...
Post a Comment
Read more