CODEWITHSUNDEEP
excelpivot-tablepowerpivotdax
NickP
NickP

Reputation: 1414

Ignore filters on metric (in row)

I just realized that a lot of my calculations are off because I have one metric which relies on looking at many years of data.

However, on all PivotTables where I have to show this metric (which should ignore filters) - it applies the date ranges of the PivotTable.

How would I set just this metric (referenced in a row with year columns) to ignore all filters?

EDIT: I have already tried ALLEXCEPT() but this seems to work just for columns and this metric is added in Values to be shown across rows split into columns by years.

Upvotes: 0

Views: 223

Answers (1)

greggyb
greggyb

Reputation: 3798

Measure:=
CALCULATE(
    <expression>
    ,ALL( 'FactTAble' )
)

Upvotes: 1

Related Questions