Forum Discussion

Emanuel's avatar
Emanuel
Icon for Helper I rankHelper I
3 years ago
Solved

Check if value exists in another table based on a specific category

I have 2 tables Problem table and Problem workinfo table and I need the following output: Problem table   Problem work info table   OUTPUT Problem ID   Problem ID Type   Problem ID D...
  • v-jianboli-msft's avatar
    v-jianboli-msft
    3 years ago

    Hi Emanuel ,

     

    Approve with Anonymous .

    Here's a way to achieve it via Measure:

    Does it have a "Resolution Communication" work info type? = IF("Resolution Communications" in SELECTCOLUMNS('Problem work info table',"Type",[Type]),"yes","no")

    Final output:

    Best Regards,

    Jianbo Li

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-jianboli-msft's avatar
v-jianboli-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi Emanuel ,

 

Approve with Anonymous .

Here's a way to achieve it via Measure:

Does it have a "Resolution Communication" work info type? = IF("Resolution Communications" in SELECTCOLUMNS('Problem work info table',"Type",[Type]),"yes","no")

Final output:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Emanuel's avatar
Emanuel
Icon for Helper I rankHelper I
3 years ago

Thanks Li for your solution.

How can I include this measure in a larger calculation?
So, what I need is to create a measure/column for KPI that has to contain the following logic: If(

Does it have a "Resolution Communication" work info type?=yes and 
Report_tgt_date<=Action Date then KPI is met else is not.
I've added 2 colums to your solution to help with the outcome (I don't know why is not letting me to insert the bi file itself)