Forum Discussion
Lookup a column value thats in my Temporary Table variable
- Anonymous5 years ago
Hi IcingOnTheCake ,
I updated my sample file and created two measures to replace the previous calculated columns since you want to display data dynamically.
Best Regards
Hi IcingOnTheCake ,
Please review the content in the following links and check whether they can help you resolve the problem.
Unexpected error occurred (file 'tmsavepointvalidation.cpp', line 458
Version: 2.79.5768.721 64-bit (mars 2020) - Error when "Apply query changes"
KB4014013 - FIX: Unexpected error occurs when you process a table in a tabular model in SSAS 2016
Best Regards
Hi again,
ok. That unexpected error disappeared after reopening the file.
At the end the below is the solution.
I had to add one more line to your code.
Had to do this, because all filters where always (company, slicers....) ignored and only with that line:
If (isempty(invoice),blank(),..........)
it worked.
Actually I dont know why this is needed. I found it while googling but without any useful explanation.
Can you explain, why this is needed?
Thank you and thank y for all your help with the code!