Creating a measure that is independent of filters

[PowerBIUser99]

Hi all,

I hope that there is one in this community who could be helpful - I have two measures: 1) YTD numbers and 2) FY numbers. However, on the report there is also a filter on months, so what I need is to create a function of FY numbers to be independent of the filtering from the variable months.

Can anybody be helpful here?

[amitchandak]

@PowerBIUser99 , If FY is current FY ?

One way is

New FY = calculate([FY], removefilters(Date[Month Year]))

or

New FY = calculate([FY], all(Date]))

Here FY should have its own filter for date

or

calculate(Sum(Table[Value]), filter(all(Date), [FY] = max([FY]))

or use slicer on an independent date table

[PowerBIUser99]

@amitchandak Thank you for the response. I tried all three measures, but none of them worked.

See the picture, in one table I have YTD and FY giving the exact same amount because of filtering Year-To-Date, however the table next is giving the exact amount supposed for FY. I need a measure for the one in the table to the left giving the same amount as the one in the right. 

[amitchandak]

@PowerBIUser99 ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[PowerBIUser99]

@amitchandak Nevermind, I took the wrong month variable, which was the reason behind the measure not working! Sorry, but also thank you! Now it works perfectly 😄