How to create constant value for all the years

[9fsabor]

Hello, 

I tried to have a fixed amount for all the months. I somehow able to show it up but only for the year Fy21. I don't know why it is not showing up in Fy22. Any idea? Thank you. 

[bcdobbs · Accepted solution]

Hi,

It looks like you're removing Period from the filter context but that will leave you Financial Year active.

From your picture June 2021 not in FY 2022 and so there is no result.

A picture of your date table would help.

What happens if you do this:

Base Amount for Portfolio Trend = 
    CALCULATE(
        [Outstanding_Loans_Amount],
        'Date'[Month Year 2] IN { "Jun 2021" },
        REMOVEFILTERS('Date')
    )

[9fsabor]

Hello! It's working now! Thank you so much! 

 

[ValtteriN]

Hi, 

My first insctinct is to put ALL before the filter condition and remove [period] from the measure. It is pretty difficult to get to the root of the problem without seeing the Date table.