Forum Discussion

gduobaite's avatar
gduobaite
Helper III
5 years ago
Solved

Retrieve values from another table

Hi all,    I have two tables (Table & Table(2)) related through "z_score_rnd" column. I need to show "100" (number) value in "score %" colum for the scores, which are >=4 or <=-4 from Table(2). I...
Need Help
  • v-yingjl's avatar
    v-yingjl
    5 years ago

    Hi gduobaite ,

    You can create this column:

     

    Column =
IF (
     ( [z_score_rnd] >= 4
        || [z_score_rnd] <= -4 )
        && [z_score_rnd] IN DISTINCT ( 'Table (2)'[z_score_rnd] ),
    100,
    [score %]
)

     

    Attached the file in the below, hopes to help you.

     

    Best Regards,
    Community Support Team _ Yingjie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

vanessafvg's avatar
vanessafvg
Community Champion
5 years ago

you will need to add your pbix to dropbox or something similar so we can download from there.