Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Custom filter for a calculated measure

Hi all. I have a custom measure which obtains a value via LOOKUPVALUE. It basically compares values in a column is table A with those in table be. When it finds a match (a string) it returns the val...
ERD's avatar
ERD
Icon for Community Champion rankCommunity Champion
3 years ago

Anonymous , create a separate table with possible values with no connections. Use it for the slicer and change your measure accordingly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    But how? I don't seem to be able to bring over columns from those 2 tables (say, Table A and B) into a new table.

    I can create a table alright, but I can only bring in columns from one of those tables (I tried vie SUMMARIZE()).

    For clarification, Table A is in DirectQuery mode, and Table B is in import mode - i'm not sure whethter that has anything to do with the issue I'm facing?

    TO create a new table was the first thing that came to mind but it's simply not working for me...