Bypassing field in calculated dimension

[aatish12345]

Hi All,

I have below calculated dimension for "SalesDate" in straight table:

Aggr(Only( [SalesDate]={"=[SalesDate]<=ReportingDate"}>}[SalesDate]),
[SalesDate])...In this calculated dimension I want to bypass Region field, I have done it as shown below

Aggr({<[Region]=>} Only( [SalesDate]={"=[SalesDate]<=ReportingDate"},[Region]=>}[SalesDate]),
[SalesDate])

The expression syntax is OK but in the Region filter is still getting applied on the data.

I want to know is there any other way of bypassing the region field in order to avoid its selection on the data.

Aatish

[BrunPierre]

Hi, How about an expression just like this and then using [SalesDate] as the dimension?

AggregationFunction ({$<[Region]=, [SalesDate]={"<=$(=ReportingDate)"}>} Measure)

[aatish12345]

Using only on the top of my expression wont allow the table to populat data as it is a date field used as dimension

[aatish12345]

 
this is the error , since it is a calculated dimn so aggr function like only() it is not allowing

[BrunPierre]

---

Hi, How about an expression just like this and then using [SalesDate] as the dimension?

AggregationFunction ({$<[Region]=, [SalesDate]={"<=$(=ReportingDate)"}>} Measure)

[BrunPierre]

Hi, How about an expression just like this and then using [SalesDate] as the dimension?

AggregationFunction ({$<[Region]=, [SalesDate]={"<=$(=ReportingDate)"}>} Measure)

[aatish12345]

I will get back to you

[aatish12345]

Hi, 

You mean adding another expression with aggregation function and then using SalesDate as a dimension?

Aatish

[BrunPierre]

Something like.

Sum({$<[Region]=, [SalesDate]={"<=$(=ReportingDate)"}>} Sales)

[aatish12345]

I cant use sum function since the field is Date field and not any numeric field.

[BrunPierre]

If you want to show the dates as measure, then maybe something like this.

Only({$<[Region]=, [SalesDate]={"<=$(=ReportingDate)"}>} [Date field])