🎯 Interview Questions

1️⃣ What does CALCULATE() do?

It evaluates an expression after modifying the filter context.

2️⃣ What is the difference between ALL() and REMOVEFILTERS()?

Both can remove filters, but REMOVEFILTERS() clearly communicates that the intention is to remove filters.

3️⃣ What is ALLSELECTED() used for?

It helps calculate results based on the user's selected context while ignoring certain visual-level filters.

4️⃣ What is KEEPFILTERS()?

It preserves existing filters when applying additional filters.

5️⃣ What is context transition?

The conversion of row context into filter context, typically triggered by CALCULATE().

🧪 PRACTICE

Create these measures:

Total Sales

West Sales

Total Sales All Regions

Sales % of Total

Sales % of Selected Regions

Then add:

✔ Region slicer

✔ Category slicer

✔ Sales by Region chart

Change the slicers and observe how each measure behaves.

That observation is one of the best ways to understand DAX filter context.

💡 Key lesson:

Don't memorize CALCULATE().

Understand what filters exist, which filters you want to change, and what result you expect.

Double Tap ❤️ For More

𝗜𝗻𝗳𝗼𝘀𝘆𝘀 𝗠𝗼𝘀𝘁 𝗔𝘀𝗸𝗲𝗱 𝗜𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄 𝗤𝘂𝗲𝘀𝘁𝗶𝗼𝗻𝘀 & 𝗔𝗻𝘀𝘄𝗲𝗿𝘀😍
​
✅ Real Interview Experiences
✅ Company-specific Handbook
✅ Interview Process & Preparation Roadmap
✅ FREE Preparation Resources
​
Specialist Programmer :- https://pdlink.in/4xDH2lD
​
​ Systems Engineer :- https://pdlink.in/4xAhGoL
​
​Infosys Digital Specialist Engineer :- https://pdlink.in/4yJ98gb
​
​The best way to prepare is to learn from candidates who've already been through the process.
​

🚀 Data Analyst Roadmap — Part 27

POWER BI LEVEL 6 — DAX TIME INTELLIGENCE

Time-based analysis is one of the most important things you will do in Power BI.

Businesses commonly ask:
👉 How much did sales grow this month?
👉 How does this year compare with last year?
👉 What was the sales total year-to-date?
👉 Which month had the highest sales?
👉 Are we growing or declining over time?

DAX Time Intelligence helps answer these questions.

🔹 1. You need a proper Date Table

Before using time-intelligence functions, create a dedicated Date table.

Example:
Date =
CALENDAR(
DATE(2024,1,1),
DATE(2026,12,31)
)

Then create useful columns:
• Year
• Month
• Month Number
• Quarter
• Year-Month

Sort Month by Month Number so that January → February → March →... → December instead of alphabetical ordering.

Mark the table as a Date table in Power BI.

🔹 2. Total Sales

Start with a basic measure:
Total Sales =
SUM(Sales[SalesAmount])

This becomes the foundation for most time-based calculations.

🔹 3. Year-to-Date — TOTALYTD()

YTD means Year To Date. It calculates the cumulative value from the beginning of the year up to the current date.

Example:
Sales YTD =
TOTALYTD(
[Total Sales],
'Date'[Date]
)

If the current month is June, the measure calculates: January + February + March + April + May + June

🔹 4. Previous Year Sales

To compare the current period with the same period last year:
Sales LY =
CALCULATE(
[Total Sales],
SAMEPERIODLASTYEAR('Date'[Date])
)

If the current visual shows March 2026, this measure returns March 2025 sales.

🔹 5. Year-over-Year Growth

Now compare current sales with last year:
YoY Growth =
[Total Sales] - [Sales LY]

YoY Growth % =
DIVIDE(
[Total Sales] - [Sales LY],
[Sales LY]
)

Example:
• Current Year Sales = ₹120 lakh
• Previous Year Sales = ₹100 lakh
• Growth = ₹20 lakh
• Growth % = 20%

🔹 6. DATEADD()

DATEADD() shifts the current date context.

Previous Month Sales:
Sales Previous Month =
CALCULATE(
[Total Sales],
DATEADD(
'Date'[Date],
-1,
MONTH
)
)

Previous Year:
Sales Previous Year =
CALCULATE(
[Total Sales],
DATEADD(
'Date'[Date],
-1,
YEAR
)
)

You can shift by:
• DAY
• MONTH
• QUARTER
• YEAR

🔹 7. Month-over-Month Growth

First calculate previous month sales:
Sales PM =
CALCULATE(
[Total Sales],
DATEADD(
'Date'[Date],
-1,
MONTH
)
)

MoM Growth % =
DIVIDE(
[Total Sales] - [Sales PM],
[Sales PM]
)

Example:
• January = ₹10 lakh
• February = ₹12 lakh
• MoM Growth = 20%

🔹 8. TOTALMTD() and TOTALQTD()

Similar to TOTALYTD():

MTD = Month To Date
Sales MTD =
TOTALMTD(
[Total Sales],
'Date'[Date]
)

QTD = Quarter To Date
Sales QTD =
TOTALQTD(
[Total Sales],
'Date'[Date]
)

So you can analyze:
• MTD → current month progress
• QTD → current quarter progress
• YTD → current year progress

🔹 9. Why Date Tables Matter

Suppose your sales table contains Order Date, Customer, Product, Sales. You could try to perform time calculations directly on Order Date, but a dedicated Date table gives you a consistent calendar for:
• ✔ Year
• ✔ Quarter
• ✔ Month
• ✔ Week
• ✔ YTD
• ✔ MTD
• ✔ QTD
• ✔ Previous period
• ✔ YoY
• ✔ MoM

This becomes especially important when working with multiple fact tables.

🔹 10. A Common Mistake

Don't create every time calculation as a calculated column.
Avoid creating separate columns for:
• Previous Year Sales
• YTD Sales
• MoM Growth
• YoY Growth

These are generally better as measures because they need to respond dynamically to filters and report context.

🎯 Interview Questions

1️⃣ What is Time Intelligence in Power BI?
It is the use of DAX functions to perform calculations across dates and periods.

2️⃣ Why do we need a Date table?
It provides a consistent calendar structure for reliable time-based analysis.

3️⃣ What does SAMEPERIODLASTYEAR() do?
It returns the corresponding period from the previous year.

4️⃣ What is the difference between MTD, QTD and YTD?
• MTD = Month To Date
• QTD = Quarter To Date
• YTD = Year To Date

5️⃣ What does DATEADD() do?
It shifts the current date context by a specified number of days, months, quarters, or years.

Double Tap ❤️ For More

🤖 New Powerful AI Model: GigaChat 3.5 Reasoning

This open-source LLM actually thinks before it answers! Perfect for complex coding, math, and reasoning prompts.

✅ Built on GigaChat 3.5 Ultra: explores multiple step-by-step reasoning paths

✅ Automated verification reinforces correct answers, enabling self-correction

✅ Autonomously decides when to call external tools or revise earlier steps

✅ Highly efficient: Linear attention uses 37% fewer tokens than DeepSeek V4 Flash Preview

📈 Massive benchmark gains over non-reasoning versions:
• IFBench: 44 → 77
• Natural Plan: 64 → 80
• LiveCodeBench v6: 56 → 85

🔗 Open-sourced under MIT license. Weights on Hugging Face: fp8 | bf16

🎓 𝐅𝐑𝐄𝐄 𝐈𝐁𝐌 𝐂𝐞𝐫𝐭𝐢𝐟𝐢𝐜𝐚𝐭𝐢𝐨𝐧 𝐂𝐨𝐮𝐫𝐬𝐞𝐬 🚀

Explore these beginner-friendly courses and strengthen your resume!

🎯 Perfect for Students, Freshers and Working Professionals
💻 Learn Online at Your Own Pace
📜 Earn Certificates After Successful Completion

🔗 𝗘𝗻𝗿𝗼𝗹𝗹 𝗳𝗼𝗿 𝗙𝗥𝗘𝗘 👇:-

https://pdlink.in/45KgqDR

🔥 Don’t just collect certificates—build skills that employers value. Share this with your friends!

🚀 Data Analyst Roadmap — Part 28

POWER BI LEVEL 7 — DAX ITERATORS: SUMX, AVERAGEX, COUNTX & VIRTUAL CALCULATIONS

You already know functions like "SUM()" and "AVERAGE()". But sometimes a business calculation needs to happen row by row before the final result is calculated. That's where DAX iterators become important.

🔹 1. What is an Iterator?

Iterator functions evaluate an expression for each row of a table and then combine the results.

Common iterators include: "SUMX()", "AVERAGEX()", "COUNTX()", "MINX()", "MAXX()"

🔹 2. SUM() vs SUMX()

Suppose your Sales table has: Quantity, Unit Price. You want total revenue.

With "SUM()", you can directly add a column:

Total Sales = SUM(Sales[SalesAmount])

But if SalesAmount doesn't exist and you need Quantity × Unit Price you can use "SUMX()":

Total Sales =

SUMX(

    Sales,

    Sales[Quantity] * Sales[UnitPrice]

)

DAX evaluates: Row 1 → Quantity × Price, Row 2 → Quantity × Price, Row 3 → Quantity × Price, Then adds all the results.

🔹 3. AVERAGEX()

Suppose you want the average revenue generated by each transaction:

Average Sales =

AVERAGEX(

    Sales,

    Sales[Quantity] * Sales[UnitPrice]

)

The expression is calculated for every row first. Then the average is calculated.

🔹 4. COUNTX()

"COUNTX()" counts the number of non-blank results produced by an expression.

Transactions With Value =

COUNTX(

    Sales,

    Sales[Quantity] * Sales[UnitPrice]

)

This can be useful when the calculation itself determines whether a value exists. For simply counting rows, however, "COUNTROWS()" is usually clearer:

Transaction Count = COUNTROWS(Sales)

🔹 5. MINX() and MAXX()

You can also find the minimum or maximum value from a calculated expression.

Highest Transaction =

MAXX(

    Sales,

    Sales[Quantity] * Sales[UnitPrice]

)

Lowest Transaction =

MINX(

    Sales,

    Sales[Quantity] * Sales[UnitPrice]

)

🔹 6. Iterators Create Row Context

This is one of the most important DAX concepts. Inside:

SUMX(

    Sales,

    Sales[Quantity] * Sales[UnitPrice]

)

DAX evaluates the expression for the current row. That is called: Row Context.

So: "SUM()" → directly aggregates a column, "SUMX()" → evaluates an expression row by row and then aggregates the result

🔹 7. A Practical Profit Example

Suppose your table contains: Quantity, Sales Price, Cost Price. You can calculate total profit without creating a Profit column:

Total Profit =

SUMX(

    Sales,

    (Sales[SalesPrice] - Sales[CostPrice]) * Sales[Quantity]

)

This is extremely useful because the calculation happens dynamically inside the measure.

🔹 8. Iterators with CALCULATE()

Iterators become even more powerful when combined with "CALCULATE()". For example, you might want to calculate sales only for high-value transactions:

High Value Sales =

SUMX(

    FILTER(

        Sales,

        Sales[SalesAmount] > 10000

    ),

    Sales[SalesAmount]

)

Here: "FILTER()" → creates the relevant set of rows, "SUMX()" → evaluates and adds the values. This combination appears frequently in real Power BI projects.

🔹 9. Virtual Tables

DAX can create temporary tables during a calculation. These are called: Virtual Tables. They aren't permanently stored in your model.

For example:

High Value Sales =

CALCULATE(

    [Total Sales],

    FILTER(

        Sales,

        Sales[SalesAmount] > 10000

    )

)

The filtered table exists only while the calculation is being evaluated.

🔹 10. SUMX() with Related Tables

Iterators can also work with relationships.

Suppose: Product table contains: Product ID, Product Name, Cost. Sales table contains: Product ID, Quantity.

You could calculate total cost using:

Total Cost =

SUMX(

    Sales,

    Sales[Quantity] * RELATED(Product[Cost])

)

"RELATED()" retrieves the related product cost for the current Sales row. Then "SUMX()" performs the calculation for every sales row.

🔹 11. When Should You Use SUMX()?

Use "SUMX()" when the calculation requires an expression. For example: Quantity × Price, Quantity × Cost, Revenue − Cost, Discount × Quantity, Price × Exchange Rate

If the value already exists in a column and you simply need the total, "SUM()" is usually simpler.

🎯 Interview Questions

1️⃣ What is an iterator in DAX? - A function that evaluates an expression row by row over a table.

2️⃣ What is the difference between SUM() and SUMX()? - "SUM()" directly aggregates a column, while "SUMX()" evaluates an expression for each row before aggregating.

3️⃣ What does the X in SUMX() represent? - It indicates that the function iterates through rows and evaluates an expression.

4️⃣ What is row context? - The context representing the current row while DAX evaluates an expression.

5️⃣ Can SUMX() work with FILTER()? - Yes. FILTER() can define the rows to process, while SUMX() performs the row-by-row calculation.

🧪 PRACTICE

Create a Sales table containing: Customer, Product, Quantity, Unit Price, Unit Cost

Then create: Total Sales using SUMX(), Total Cost using SUMX(), Total Profit using SUMX(), Average Transaction Value using AVERAGEX(), Highest Transaction using MAXX()

Finally, add: Region slicer, Product slicer, Month slicer. Change the filters and observe how your measures respond.

Power BI Resources: https://t.me/PowerBI_analyst

💡 Double Tap ❤️ For More

𝗙𝗥𝗘𝗘 𝗔𝗜 𝗖𝗮𝗿𝗲𝗲𝗿 𝗠𝗮𝘀𝘁𝗲𝗿𝗰𝗹𝗮𝘀𝘀 🚀

Join this expert-led masterclass and discover how to become industry-ready for high-growth AI roles.

📅 Date: 24 September 2026
⏰ Time: 7:00 PM–9:00 PM IST
🌐 Mode: Online
🎓 Certificate: Available to all attendees

Eligibility :- Graduates Passing In 2025 or earlier

🔗 𝗥𝗲𝗴𝗶𝘀𝘁𝗲𝗿 𝗳𝗼𝗿 𝗙𝗥𝗘𝗘 👇

https://pdlink.in/4xAMeGW

⚡ Register now and take your first step towards a successful career in AI!

🚀 𝗧𝗼𝗽 𝟳 𝗙𝗥𝗘𝗘 𝗠𝗶𝗰𝗿𝗼𝘀𝗼𝗳𝘁 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 𝘁𝗼 𝗟𝗲𝗮𝗿𝗻 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀! 📊

Want to start a career in Data Analytics?

Explore these 7 free Microsoft-backed learning resources covering Power BI, Excel, SQL and data fundamentals

🔗 𝗔𝗰𝗰𝗲𝘀𝘀 𝘁𝗵𝗲 𝗙𝗥𝗘𝗘 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 👇

https://pdlink.in/3Tm2D3Z

💡 Ideal for students, freshers and professionals who want to build practical data skills.

🚀 SQL & Python Quick Cheatsheet for Beginners

🗄️ SQL Programming

1. What is SQL?

SQL stands for Structured Query Language. It is used to communicate with databases and work with stored data.

You can use SQL to:

✅ Retrieve data

✅ Filter data

✅ Analyze data

✅ Insert data

✅ Update data

✅ Delete data

2. SELECT

Used to retrieve data from a table.

SELECT name, salary
FROM employees;

SELECT → columns you want

FROM → table you want data from

To get all columns:

SELECT *
FROM employees;

3. WHERE

Used to filter rows.

SELECT *
FROM employees
WHERE salary > 50000;

Common operators:

= Equal

Greater than

< Less than

= Greater than or equal

<= Less than or equal

<> Not equal

4. AND, OR, NOT

Used to combine conditions.

SELECT *
FROM employees
WHERE salary > 50000
AND department = 'IT';

AND → both conditions must be true.

SELECT *
FROM employees
WHERE department = 'IT'
OR department = 'HR';

OR → at least one condition must be true.

5. ORDER BY

Used to sort your results.

SELECT *
FROM employees
ORDER BY salary DESC;

ASC → Lowest to highest

DESC → Highest to lowest

6. DISTINCT

Used to remove duplicate values.

SELECT DISTINCT department
FROM employees;

7. LIMIT

Used to restrict the number of rows returned.

SELECT *
FROM employees
LIMIT 10;

Note: Some databases use TOP or FETCH.

8. Aggregate Functions

Used to perform calculations on multiple rows.

COUNT() -- Count

SUM() -- Total

AVG() -- Average

MIN() -- Minimum

MAX() -- Maximum

Example:

SELECT AVG(salary)
FROM employees;

9. GROUP BY

Used to create groups and calculate results for each group.

SELECT
    department,
    AVG(salary) AS average_salary
FROM employees
GROUP BY department;

10. HAVING

Used to filter grouped results.

SELECT
    department,
    AVG(salary) AS average_salary
FROM employees
GROUP BY department
HAVING AVG(salary) > 70000;

WHERE → filters rows

HAVING → filters groups

🐍 Python — Beginner Fundamentals

1. What is Python?

Python is a general-purpose programming language used for:

✅ Data Analytics

✅ Automation

✅ AI & Machine Learning

✅ Data Engineering

✅ Web Development

2. Variables

Variables store values.

name = "Alex"
age = 25
salary = 50000

3. Data Types

Important beginner data types:

name = "Alex" # str
age = 25 # int
salary = 50000.5 # float
active = True # bool

type(age)

4. Strings

Strings represent text.

name = "Python"

name.upper() # PYTHON
name.lower() # python
name.strip() # removes spaces

5. Numbers

Python supports integers and floating-point numbers.

age = 25
price = 99.50

10 + 5 # Addition
10 - 5 # Subtraction
10 * 5 # Multiplication
10 / 5 # Division
10 % 3 # Remainder
10 ** 2 # Power

6. Boolean

Boolean values represent True or False.

is_logged_in = True

7. Lists

Lists store multiple values in an ordered collection.

numbers = [10, 20, 30, 40]

numbers[0] # Output: 10

Python indexing starts from 0.

8. Dictionaries

Dictionaries store data as key-value pairs.

employee = {
    "name": "Alex",
    "age": 25,
    "salary": 50000
}

employee["name"] # Output: Alex

9. Tuples

Tuples store ordered values that cannot normally be changed.

coordinates = (10, 20)

10. Sets

Sets store unique values.

numbers = {1, 2, 2, 3}
# Result: {1, 2, 3}

SQL Resources: https://whatsapp.com/channel/0029VanC5rODzgT6TiTGoa1v

❤️ Double Tap & React For More!

🚀 𝐁𝐞𝐜𝐨𝐦𝐞 𝐚𝐧 𝐀𝐈 𝐄𝐧𝐠𝐢𝐧𝐞𝐞𝐫 𝐢𝐧 𝟐𝟎𝟐𝟔

🎯 Choose Your Learning Track:

💻 Java Full Stack + AI Engineering
🌐 MERN Full Stack + AI Engineering

Placement Highlights: ₹41 LPA highest package | ₹7.4 LPA average package | 2,000+ students placed | 500+ hiring partners

🔗 𝗕𝗼𝗼𝗸 𝗙𝗥𝗘𝗘 𝗗𝗲𝗺𝗼 𝗖𝗹𝗮𝘀𝘀 :- https://pdlink.in/4fWJVID

⚡ AI is creating new career opportunities—start building the skills companies need in 2026!

Born to vibe. Forced to survive.

Learn SQL from basic to advanced level in 30 days

Week 1: SQL Basics

Day 1: Introduction to SQL and Relational Databases

Overview of SQL Syntax

Setting up a Database (MySQL, PostgreSQL, or SQL Server)


Day 2: Data Types (Numeric, String, Date, etc.)

Writing Basic SQL Queries:

SELECT, FROM

Day 3: WHERE Clause for Filtering Data

Using Logical Operators:

AND, OR, NOT

Day 4: Sorting Data: ORDER BY

Limiting Results: LIMIT and OFFSET

Understanding DISTINCT

Day 5: Aggregate Functions:

COUNT, SUM, AVG, MIN, MAX


Day 6: Grouping Data: GROUP BY and HAVING

Combining Filters with Aggregations


Day 7: Review Week 1 Topics with Hands-On Practice

Solve SQL Exercises on platforms like HackerRank, LeetCode, or W3Schools


Week 2: Intermediate SQL

Day 8: SQL JOINS:

INNER JOIN, LEFT JOIN

Day 9: SQL JOINS Continued: RIGHT JOIN, FULL OUTER JOIN, SELF JOIN

Day 10: Working with NULL Values

Using Conditional Logic with CASE Statements

Day 11: Subqueries: Simple Subqueries (Single-row and Multi-row)

Correlated Subqueries

Day 12: String Functions:

CONCAT, SUBSTRING, LENGTH, REPLACE

Day 13: Date and Time Functions: NOW, CURDATE, DATEDIFF, DATEADD

Day 14: Combining Results: UNION, UNION ALL, INTERSECT, EXCEPT

Review Week 2 Topics and Practice

Week 3: Advanced SQL

Day 15: Common Table Expressions (CTEs)

WITH Clauses and Recursive Queries

Day 16: Window Functions:

ROW_NUMBER, RANK, DENSE_RANK, NTILE

Day 17: More Window Functions:

LEAD, LAG, FIRST_VALUE, LAST_VALUE


Day 18: Creating and Managing Views

Temporary Tables and Table Variables

Day 19: Transactions and ACID Properties

Working with Indexes for Query Optimization

Day 20: Error Handling in SQL

Writing Dynamic SQL Queries


Day 21: Review Week 3 Topics with Complex Query Practice

Solve Intermediate to Advanced SQL Challenges



Week 4: Database Management and Advanced Applications

Day 22: Database Design and Normalization:

1NF, 2NF, 3NF


Day 23: Constraints in SQL:
PRIMARY KEY, FOREIGN KEY, UNIQUE, CHECK, DEFAULT


Day 24: Creating and Managing Indexes

Understanding Query Execution Plans

Day 25: Backup and Restore Strategies in SQL

Role-Based Permissions

Day 26: Pivoting and Unpivoting Data

Working with JSON and XML in SQL

Day 27: Writing Stored Procedures and Functions

Automating Processes with Triggers

Day 28: Integrating SQL with Other Tools (e.g., Python, Power BI, Tableau)

SQL in Big Data: Introduction to NoSQL

Day 29: Query Performance Tuning:

Tips and Tricks to Optimize SQL Queries


Day 30: Final Review of All Topics

Attempt SQL Projects or Case Studies (e.g., analyzing sales data, building a reporting dashboard)

Since SQL is one of the most essential skill for data analysts, I have decided to teach each topic daily in this channel for free. Like this post if you want me to continue this SQL series 👍♥️

Share with credits: https://t.me/sqlspecialist

Hope it helps :)

🚀 𝗚𝗼𝗼𝗴𝗹𝗲 𝗣𝗿𝗼𝗳𝗲𝘀𝘀𝗶𝗼𝗻𝗮𝗹 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗲𝘀 𝗶𝗻 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 & 𝗔𝗜! 📊

Explore these 4 Google learning programs and develop practical, career-relevant skills.

🎓 Explore the programs:
1️⃣ Google Data Analytics Professional Certificate
2️⃣ Google Business Intelligence Professional Certificate
3️⃣ Google AI Essentials
4️⃣ Google Advanced Data Analytics Professional Certificate

🔗 𝗘𝗻𝗿𝗼𝗹𝗹 𝗳𝗼𝗿 𝗙𝗥𝗘𝗘 👇:-

https://pdlink.in/4htgIEW

📌 Save this post and share it with someone interested in Data Analytics or AI!

🚀 Data Analyst Roadmap — Part 29

POWER BI LEVEL 8 — ADVANCED DAX: FILTER(), VALUES(), SELECTEDVALUE() & DYNAMIC CALCULATIONS

Now let's move into DAX functions that help you build more dynamic Power BI reports.

These functions are especially useful when your calculation needs to react to slicers, selections, or the current report context.

🔹 1. FILTER()

You already know that FILTER() can create a filtered table.

Example:

High Value Sales =
CALCULATE(
    [Total Sales],
    FILTER(
        Sales,
        Sales[SalesAmount] > 10000
    )
)

This keeps only transactions where SalesAmount is greater than 10,000.

The important thing to understand:

• "FILTER()" works with a table and evaluates a condition for each row.

• Use it when your filtering requirement is more complex than a simple condition.

🔹 2. VALUES()

"VALUES()" returns the unique values from a column based on the current filter context.

Example:

Customer Count =
COUNTROWS(
    VALUES(Sales[CustomerID])
)

This counts the unique customers visible in the current context.

For example:

• Without filters → 1,000 customers

• Region = West → 250 customers

• Region = South → 300 customers

The result changes according to the report filters.

🔹 3. VALUES() vs DISTINCT()

Both can return unique values, but they aren't identical in every situation.

A useful beginner-level rule:

• "DISTINCT()" → returns unique values from a column.

• "VALUES()" → returns unique values while also being sensitive to the current DAX context and can include a blank value when appropriate.

In advanced DAX, "VALUES()" is extremely useful for understanding what values are currently available in the filter context.

🔹 4. SELECTEDVALUE()

This is one of the most useful functions for interactive reports.

Suppose you have a Region slicer.

You can write:

Selected Region =
SELECTEDVALUE(
    Sales[Region],
    "Multiple Regions"
)

If the user selects:

• West → Result: West

• West + South → Result: Multiple Regions

If nothing is selected, the result can also return the alternate value depending on the filter context.

🔹 5. SELECTEDVALUE() with Dynamic Titles

You can use SELECTEDVALUE() to make report titles dynamic.

Example:

Sales Title =
"Sales Performance - "
&
SELECTEDVALUE(
    Sales[Region],
    "All Regions"
)

If the user selects West:

• Sales Performance - West

If multiple regions are selected:

• Sales Performance - All Regions

This makes dashboards much more interactive.

🔹 6. HASONEVALUE()

"HASONEVALUE()" checks whether exactly one unique value exists in the current filter context.

Example:

Single Region Selected =
IF(
    HASONEVALUE(Sales[Region]),
    "One Region",
    "Multiple Regions"
)

If exactly one region is selected:

• One Region

Otherwise:

• Multiple Regions

🔹 7. SELECTEDVALUE() vs HASONEVALUE()

They are related but serve different purposes.

"HASONEVALUE()" asks:

• "Is exactly one value selected?"

"SELECTEDVALUE()" asks:

• "What is that selected value?"

For example:

SELECTEDVALUE(Sales[Region]) returns the actual region.

HASONEVALUE(Sales[Region]) returns TRUE or FALSE.

🔹 8. Dynamic KPI Calculation

Suppose you want a KPI to change based on a slicer containing:

• Sales

• Profit

• Orders

A measure can use the selected value to determine what should be displayed.

Conceptually:

Selected KPI =
SWITCH(
    SELECTEDVALUE(KPI[KPI Name]),
    "Sales", [Total Sales],
    "Profit", [Total Profit],
    "Orders", [Total Orders]
)

Now one visual can display different KPIs based on the user's selection.

This is called a:

• 👉 Dynamic Measure

🔹 9. SWITCH()

"SWITCH()" is extremely useful for dynamic DAX.

Instead of writing many nested IF statements:

Performance =
SWITCH(
    TRUE(),
    [Profit Margin] >= 0.30, "Excellent",
    [Profit Margin] >= 0.15, "Good",
    [Profit Margin] >= 0, "Needs Improvement",
    "Loss"
)

It evaluates conditions and returns the corresponding result.

This is useful for:

✔ KPI categories

✔ Business rules

✔ Dynamic labels

✔ Conditional calculations

✔ Performance classification

🔹 10. Building a Dynamic Customer Message

You can combine these functions to create business-friendly messages.

Example:

Customer Message =
"Selected Customers: "
&
COUNTROWS(VALUES(Sales[CustomerID]))

If the current filter context contains 125 unique customers:

• Selected Customers: 125

This can be displayed inside a Card or used in a report title.

🔹 11. Why These Functions Matter

Real dashboards rarely show the same calculation under every situation.

Users interact with:

• Slicers

• Filters

• Drill-downs

• Cross-highlighting

• Page filters

Your DAX measures should respond appropriately.

Functions such as:

• "FILTER()"

• "VALUES()"

• "SELECTEDVALUE()"

• "HASONEVALUE()"

• "SWITCH()"

help you build that dynamic behavior.

🎯 Interview Questions

1️⃣ What does FILTER() do?

• It returns a filtered table based on a specified condition.

2️⃣ What does SELECTEDVALUE() return?

• The single value in the current context, or an alternate result when there isn't exactly one value.

3️⃣ What is HASONEVALUE() used for?

• To check whether exactly one unique value exists in the current filter context.

4️⃣ How can SELECTEDVALUE() be used in a dashboard?

• It can create dynamic titles, labels, messages, and calculations based on slicer selections.

5️⃣ Why is SWITCH() useful in DAX?

• It allows multiple conditions or selections to determine which result should be returned.

🧪 PRACTICE

Create a Region slicer.

Then create:

✔ Selected Region

✔ Customer Count

✔ Dynamic Sales Title

✔ Dynamic KPI using SWITCH()

✔ One Region / Multiple Regions indicator

Select different regions and observe how every measure responds.

💡 Key lesson:

Advanced DAX is largely about making calculations respond intelligently to the user's current context.

Once you understand:

• FILTER()

• VALUES()

• SELECTEDVALUE()

• HASONEVALUE()

• SWITCH()

you can start building genuinely interactive Power BI reports.

Double Tap ❤️ For More

𝗟𝗲𝘃𝗲𝗹 𝗨𝗽 𝗬𝗼𝘂𝗿 𝗦𝗸𝗶𝗹𝗹𝘀 𝘄𝗶𝘁𝗵 𝗧𝗵𝗲𝘀𝗲 𝗚𝗮𝗺𝗲-𝗖𝗵𝗮𝗻𝗴𝗶𝗻𝗴 𝗖𝗼𝘂𝗿𝘀𝗲𝘀!
​
Looking to learn practical, in-demand skills? These courses cover Generative AI, Cybersecurity, AI tools and Digital Marketing.

💫 Learn at your own pace
⚡Build career-relevant skills
🔥Practical learning opportunities

𝗘𝘅𝗽𝗹𝗼𝗿𝗲 𝘁𝗵𝗲 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 :-

https://pdlink.in/4z3vOYU

Save this post and share with your friends