PowerBI & DAX Measures.
From theory to practice.

I

Thread PowerBI & DAX Measures 3 weeks ago

How do filter context and row context work in DAX, and when should you use CALCULATE()?

Filter context filters rows, row context evaluates each row, and CALCULATE switches row context to filter context for advanced filtering.

Ishaan Patel Score 20

0 replies →

R

Thread PowerBI & DAX Measures 3 weeks ago

How to write efficient DAX Time Intelligence measures (YTD, Prior Year, Moving Averages)?

Efficient DAX time‑intelligence uses a proper date table, built‑in functions like TOTALYTD and SAMEPERIODLASTYEAR, and minimal filter removal.

Rajesh Sharma Score 20

0 replies →

G

Thread PowerBI & DAX Measures 3 weeks ago

What is Context Transition in DAX and why does using calculated columns degrade report performance?

Context transition converts row to filter context; avoid calculated columns because they run at refresh, inflate memory, and degrade performance.

Gaurav Bhasin Score 24

0 replies →

A

Thread PowerBI & DAX Measures 3 weeks ago

How to debug slow DAX measures using DAX Studio and Performance Analyzer?

Combine Power BI Performance Analyzer with DAX Studio Server Timings and Query Plan to locate and fix slow DAX measures.

Aravind Patel Score 20

0 replies →

R

Thread PowerBI & DAX Measures 3 weeks ago

How to implement dynamic measure switching in PowerBI using Field Parameters?

Use a Field Parameter with a SWITCH‑based master measure to dynamically swap DAX calculations in Power BI reports.

Rahul Sharma Score 20

0 replies →

I

Thread PowerBI & DAX Measures 3 weeks ago

What are Star Schema relationships in PowerBI and how to handle Many-to-Many join relationships safely?

Use a bridge table with inactive relationships and activate them via USERELATIONSHIP or TREATAS to safely handle many‑to‑many in Power BI.

Ishaan Patel Score 20

0 replies →