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.
Solved! Go to Solution.
@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
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" )
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??