📊 DAX Filter Context in Power BI

🔍 Overview

This repository contains a Power BI project that explores DAX Filter Context, a crucial concept in DAX calculations. The project focuses on Bank Loan Analysis, demonstrating how different filter contexts affect DAX formulas.

🏆 Key Objectives:

• Understand how row, column, and visual-level filters interact.
• Analyze DAX functions like CALCULATE, FILTER, ALL, and REMOVEFILTERS.
• Demonstrate real-world Bank Loan Analysis using Power BI.

---

🛠️ DAX Functions Used

1️⃣ CALCULATE Modifies filter context for an expression.

DAX

Copy Edit Total Sales = CALCULATE(SUM(Sales[Amount]), Sales[Region] = "East")

2️⃣ FILTER

Creates a table based on conditions.

DAX Copy Edit FilteredData = FILTER(Sales, Sales[Amount] > 1000)

3️⃣ ALL

Ignores existing filters.

DAX Copy Edit Total Sales (All Regions) = CALCULATE(SUM(Sales[Amount]), ALL(Sales[Region]))

4️⃣ REMOVEFILTERS

Removes all filters from a table or column.

DAX Copy Edit Total Sales Without Filters = CALCULATE(SUM(Sales[Amount]), REMOVEFILTERS(Sales))

🚀 Getting Started

📥 Clone the repository:

git clone https://github.com/your-username/DAX-Filter-Context.git