Solved: Ignore filter year selection - Page 2

vani · ‎02-10-2016

Hello everyone,

Iam trying to ignore the selection of an certain year.

I've the following measure:

Grow Year -1 = CALCULATE(SUM('Inscrições'[Value]);FILTER('Inscrições';and(not('Inscrições'[Pais]="Portugal");'Inscrições'[Ano]=max('Inscrições'[Ano])-1)))

I think that should work, bue when i change of year, the figure become empty (on this case table im using a table).

I hope you guys can help me !

Thanks !

SqlJason · ‎02-10-2016

Alright, I think I understood you now. What you want is to show the previous year no matter what year is selected. For eg, if we are on 2016, you always want to show 2015 data, even if we select 2010 or 2012 or any other year on filter.

1) Create a measure that will show the max year available in the fact table

MaxYear=CALCULATE(MAX('Fact'[Year]), ALL('Fact'[Year]))

2) Now make the measure as you want. Instead of hardcoding 2014, you can use the measure which will always return the max year available in fact, irrespective of the filter.

test=CALCULATE(SUM('Fact'[Sales]), FILTER(ALL('Fact'[Year]), 'Fact'[Year]=[MaxYear]-1))

Is this what you want? 🙂

View solution in original post

Ignore filter year selection

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024

How to Get Your Question Answered Quickly