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.
Go to Solution.
Try this COlumn
CALCULATE ( COUNTROWS ( LinkedTable1 ) ) > 0,
CALCULATE ( COUNTROWS ( LinkedTable2 ) ) > 0
View solution in original post
@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:
CALCULATE ( COUNTROWS ( TABLE B [Project] ) ) > 0,
CALCULATE ( COUNTROWS ( TABLE C [PROJECT] ) ) > 0
No i cant get powerBI to find/suggest the tables, I tried the RELATED function also...
It also asked for a table? I guess it suppose to be columns?
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??
Hi! I think did something weird in the relationship! it works now.. ! Your solution is great thanks!
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.