🔥 Power BI Interview Question of the Day

📌 Scenario:

A sales manager wants to compare each product's sales with the average sales of its category.

You have one table:

sales

• product_id
• category
• sales_amount

☑ Solution (DAX):

Category Avg Sales =
CALCULATE(
AVERAGE(sales[sales_amount]),
ALLEXCEPT(sales, sales[category])
)

Sales vs Category Avg =
sales[sales_amount] - [Category Avg Sales]

💡 Concept Tested:

CALCULATE() + ALLEXCEPT() (Calculating Category-Level Averages)

❤️ React if you want more Power BI interview questions.