Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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')
)
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')
)
Hello! It's working now! Thank you so much!
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.
Proud to be a Super User!
User | Count |
---|---|
50 | |
24 | |
18 | |
17 | |
14 |
User | Count |
---|---|
91 | |
84 | |
39 | |
25 | |
21 |