Hi,
I got a Power BI report and I am trying to automate them.
It contains some measures which calculates the development of the last 2 years.
One of the Measure written like shown.
ManthaOrderNumberDevelopment =
IF(
ISFILTERED('Date'[Date].[Date]),
ERROR("Quickmeasures mit Zeitintelligenz können nur über die von Power BI bereitgestellte Datumshierarchie oder die primäre Datumsspalte gruppiert oder gefiltert werden."),
VAR __PREV_YEAR =
CALCULATE(
DISTINCTCOUNT('Bericht 1'[Manta Order Number]),
DATEADD('Date'[Date].[Date], -1, YEAR)
)
RETURN
DIVIDE(
DISTINCTCOUNT('Bericht 1'[Manta Order Number]) - __PREV_YEAR,
__PREV_YEAR
)
)
Inserted this measure into a card allows me to filter it manually for each year.
I inserted a column called "Last year" in the same table which changes every next year and includes always the numbers of the last year.
Last Year Filter = If(year(DataLabelings[Date a Year Ago]) = 'Date'[Year],'Date'[Date].[Date])
I tried to use this column as a filter for my card. So every year the development card will change.
But when I am trying to use this as a filter my card won't filter.
Only when I am using the normal date column it will work.
And then it is only possible to change the filter manually.
I hope you get my problem, because my english isnt the best and describing the problem is really hard, without showing the report.
