Summary  
This chapter explains how to define and organize computed measures using DAX by performing basic aggregations with SUM, modifying evaluation context with CALCULATE and filters, and grouping measures in a dedicated calculation table.  

General domain of usage  
Business intelligence reporting

Begin your first hands-on experience with **DAX (Data Analysis Expressions)** by learning how to create and organize measures within a **calculation table**. This approach helps structure and manage calculations effectively, streamlining data analysis and reporting in both Power BI and Excel Power Pivot.

Alongside basic aggregation functions, you will explore the powerful `CALCULATE` function in DAX, which modifies the context of a calculation by applying filters.

To calculate the **total number of riders** from two columns, use the `SUM` function and the `+` operator:

```DAX
Total Riders =
    SUM(Pivot_Table[casual])
    + SUM(Pivot_Table[registered])
```

To compute **riders during the winter season**, use `CALCULATE` with your total riders measure and a filter condition:

```DAX
Winter Riders =
    CALCULATE(
        [Total Riders],
        Pivot_Table[Season Names] = "Winter"
    )
```

Power BI is an essential tool for any aspiring data analyst or business professional. Learn how to transform raw data into insightful visualizations and interactive dashboards, connect to various data sources, and create compelling reports for informed decision-making.

Dive into the world of Power BI and build a solid foundation. You'll cover everything from installation and setup to connecting data sources and creating your first report.

Explore essential data preparation techniques, including cleaning, transforming, and combining multiple data sources. You'll also tackle handling missing values, data profiling, and various data manipulation methods.


Master the fundamentals of data modeling, from understanding data models and creating relationships to getting the hang of DAX basics. You'll also learn to create measures and calculated columns.


Discover various visualization techniques and customize visuals for better insights. You'll also explore advanced features like slicers, filters, and drill-down/drill-through capabilities to enhance your data analysis.


Boost the usability and storytelling power of your reports by using themes, configuring report pages, and leveraging advanced features like the Analyze feature and identifying outliers. You'll also create groups, bins, and clusters for deeper insights.


DAX (Data Analysis Expressions) Basics

Awesome!

DAX (Data Analysis Expressions) Basics