Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm trying to filter the dimension of a line chart in such a way that only specific values are shown:
if([Date] < Max({$<[F_FCI_Flag]={1}>}[Date]), MonthName([Date]))
If I put only the set-analysis statement in e.g. a KPI, it yields a value.
However, for the line chart I receive an "invalid dimension" error.
Date is a shared dimension among different fact tables which is why I introduced the "Flag" in order to identify a given facts table.
Can anyone help?
Thanks!
David
or may be
If([Date] < Max({$<[F_FCI_Flag]={1}>}Total [Date]), MonthName([Date]))
In Calculated Dimension You need to aggregate data.
Try
Aggr(if([Date] < Max({$<[F_FCI_Flag]={1}>}[Date]), MonthName([Date])),Date)
or may be
If([Date] < Max({$<[F_FCI_Flag]={1}>}Total [Date]), MonthName([Date]))
works! Thanks a lot!