The Great PowerPivot FAQ - In my DAX measure, aggregations over some...

Title

In my DAX measure, aggregations over some related tables are acting upon the ENTIRE table, unfiltered by Pivot context. Why?

Answer

It is true that in a DAX measure, pivot context (row label, column label, slicer selection, etc.) is factored in, and tables in the source data are filtered by that context.

BUT that is only true for:

1) the tables that are directly filtered (ex: if [Year] is part of pivot context, then the Date table containing [Year] is directly filtered during DAX measure calculation).

AND 2) for related tables that are on the "many" side of a relationship with a filtered table.

In other words, filters from the pivot NEVER FLOW BACK "UP" from a "many" table to a "one" table.

Client/Server

Client

Topic

F - Calculations (DAX)

Purpose

Information

Answered?

Yes

Contributor

Rob Collie

Título

Resposta

Frage

Antwort

preRTM

Attachments

PowerPivotPro's FAQ Site