Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Calculated column or measure that returns values from Table A corresponding to certain values Tab B

Hi, i'd want a Calculated measure or column that returns values of column x of table A corresponding to certain values of another 'table B (for example). What dax should i write? This is because ...
"DAX " "DAX help" 'Need help'
bhanu_gautam's avatar
bhanu_gautam
Icon for Super User rankSuper User
1 year ago

Anonymous , You can try using a calculated column

CampagnaZefir =
IF (
RELATED(TableB[CodZef]) IN {"2025", "C25", "F25", "W25"},
1,
0
)

 

Anonymous's avatar
Anonymous
Not applicable
1 year ago

i can't find the column in RELATED()

  • AilleryO's avatar
    AilleryO
    Icon for Memorable Member rankMemorable Member
    1 year ago

    Hi,

     

    Some liitle things to check :

    1/ Do you have a relationship between the 2 tables in your model ?

    2/ If no, you need to build the relationship in the model view before using related.
    If yes, are you using the relationship from the table on the side 1 to the table on the side many, or from the table many to the table on the one side of relationship ?

    RELATED can be used from the many (*) to one (1), and if you are on the table being on the 1 side and want to get info from the table on the many side, then you'll need RELATEDTABLE as your results will/might not be unique.

    In case it might not be clear, herre is an image 😉

    Hope it help