Forum Discussion
Filter Context Not working with calculate
Hello,
I am in a pickle here.
I had to append two tables to use it as Dimension table but I am not getting the correct answer when I introduce YEAR in the mix.
Correct Result:
Wrong Result: When I introduce Year to the mix.
My measures are dependent on date from DATE table which is different from Append Table but there is a relationship with my fact table so not sure why it doesn't work as expected?
You can download the pbix from here.
https://drive.google.com/file/d/15cOobU8vzH9jQTdM_kYIiL6s48KBAmbd/view?usp=sharing
Thanks,
EZ
Hi Anonymous ,
Please try:
Last Year = VAR _max_date = SELECTEDVALUE ( 'Append1'[YEAR] ) VAR _last_year = CALCULATE ([This Year],Append1[YEAR] = _max_date - 1) RETURN _last_yearBest Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
1 Reply
Hi Anonymous ,
Please try:
Last Year = VAR _max_date = SELECTEDVALUE ( 'Append1'[YEAR] ) VAR _last_year = CALCULATE ([This Year],Append1[YEAR] = _max_date - 1) RETURN _last_yearBest Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data