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...
some_bih's avatar
some_bih
Icon for Community Champion rankCommunity Champion
3 years ago

Hi Anonymous did you try to put "measure" into calculated columns or create calculated table with measure definition.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    I created a new measure that compares values from 2 columns in 2 discreet tables, using a common key, via LOOKUPVALUE.

    My measure is: 

    Measure Name = LOOKUPVALUE('Table A'[Column containing values I want to search among],'Table A'[Searched column], ('Table B'[List of keys to use for the search]).
    I then put Measure Name in a table visual, which created a column in that visual called Measure Name. In this visual I have a bunch of columns I dragged from the other tables in the model.
    Now, whenever Measure Name finds a match between a value in Table A and one of the keys in Table B, it returns that value in my table visual under Measure Name.