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

Formatting Tips

1. Use tables to format data quickly Excel Tables  are an incredibly powerful way to handle a bunch of related data. Just select any cell with in the data and press CTRL+T and then Enter. And bingo, your data looks slick in no time. This has to be the best and easiest formatting tip. 2. Change colors in a snap So you have made a spreadsheet model or dashboard. And you want to change colors to something fresh. Just go to Page Layout ribbon and choose a color scheme from Colors box on top left. Microsoft has defined some great color schemes. These are well contrasted and look great on your screen. You can also define your own color schemes (to match corporate style). What more, you can even define schemes for fonts or combine both and create a new theme. 3. Use cell styles Consistency is an important aspect of formatting. By using cell styles, you can ensure that all similar information in your workbook is formatted in the same way. For example, you can color all input cells in orang...
Post a Comment
Read more

Import CSV In Power BI

  Import CSV file Click on Get Data à More à File option and select Text/CSV . Navigate to the CSV file which needs to be imported FL_insurance_sample.csv . Select the file and click on Open. FL_insurance_sampleDownload In the CSV window on top we have 3 dropdowns, preview of data and data load options.  Select Load and it will load to power query editor window. In the Power query editor the CSV file is loaded as a Queries . In power query editor we can edit, clean and transform the file as required. 3 Dropdowns and Data Load File Origin – Type of file origin. By default its 1252 Wester European (Windows). It’s the file type as per OS and region and country. Delimiter – Delimiter for column separation. By default it detects the delimiter from data , If the delimiter is not from the default options then we can select custom delimiter. Data Type Detection – By default it detects data types of columns based on top 200 rows, we can select entire data or do not detect data type ...
Post a Comment
Read more