Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
44 | |
25 | |
19 | |
16 | |
8 |
User | Count |
---|---|
70 | |
49 | |
45 | |
20 | |
16 |