Forum Discussion

IcingOnTheCake's avatar
IcingOnTheCake
Helper III
5 years ago
Solved

Lookup a column value thats in my Temporary Table variable

Hi experts,   I have the following Dax code to get "Number of ranked invoices" in certain ranges. Now I need one more information, that I need to filter my table "Invoice" in the report. The Class...
Need Help
IcingOnTheCake's avatar
IcingOnTheCake
Helper III
5 years ago

Thank you  Anonymous that you try to help me so much! I really appreciate.

I've added your solution. But now I get that error, as soon as I add the measure "class measure"

to my table visual where the classification should be shown.
Any idea why?

 

  • IcingOnTheCake's avatar
    IcingOnTheCake
    Helper III
    5 years ago

    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!