📊 Power BI Interview Q&A You Must Know 💡 (Part 2)

6️⃣ What is a Star Schema in Power BI?

✅ Star Schema is a data modeling structure where:

📌 Fact Table → Stores measurable data
📌 Dimension Tables → Store descriptive information

7️⃣ What is the difference between SUM and SUMX in DAX?

✅ SUM → Adds values from a single column

✅ SUMX → Evaluates an expression row by row, then sums the result

8️⃣ What are slicers in Power BI?

✅ Slicers are visual filters that allow users to interactively filter report data.

📌 Commonly used for:
• Date filtering
• Category selection
• Region/Product filtering

9️⃣ What is the difference between COUNT and DISTINCTCOUNT?

✅ COUNT → Counts all non-empty rows

✅ DISTINCTCOUNT → Counts only unique values

🔟 What is Row-Level Security (RLS) in Power BI?

✅ RLS restricts data access for specific users.

📌 Example:
• Managers can view all data
• Employees can view only their department data

React ♥️ for more interview questions