20 Power BI Dax Measures

Power 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