lookup between tables

[Kristofferaabo]

Hi!
I have a table which is linked to two tables thorugh the same relationship: "Project number"

I now want to make a column which returns 'Yes' if the given project number is in either of the linked tables.

Makes sense?

Krsitoffer

[Zubair_Muhammad · Accepted solution]

HI @Kristofferaabo

Try this COlumn

Column =
IF (
    OR (
        CALCULATE ( COUNTROWS ( LinkedTable1 ) ) > 0,
        CALCULATE ( COUNTROWS ( LinkedTable2 ) ) > 0
    ),
    "Yes"
)

[Kristofferaabo]

Hi,

@Zubair_Muhammad thanks for your input! always a pleasure! 

Below is by relationships, table A, B and C all have the column 'Project'. I would like to be able to have column in table A indicating whether the project is also present in table B and C. Either with a Yes, or 1 or similar..

That way I can filter it off/on

Thanks

Kristoffer

[Zubair_Muhammad]

Hi

Did you try the above formula?

[Kristofferaabo]

Yes, perhaps I misunderstand it, but it found 'find' the columns..

I tried this:

Column =
IF (
    OR (
        CALCULATE ( COUNTROWS ( TABLE B [Project] ) ) > 0,
        CALCULATE ( COUNTROWS ( TABLE C [PROJECT] ) ) > 0
    ),
    "Yes"
)

[Zubair_Muhammad]

It worked?

[Kristofferaabo]

No i cant get powerBI to find/suggest the tables, I tried the RELATED function also...

[Kristofferaabo]

It also asked for a table? I guess it suppose to be columns?

[Zubair_Muhammad]

Hi @Kristofferaabo

This is a DAX formula for a calculated column in Table A

When I use this formula using some dummy data...it works

Could you show the screen shot of the error you get?? or share your file??

[Kristofferaabo]

Hi! I think did something weird in the relationship! it works now.. ! Your solution is great thanks!