Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
Try this COlumn
Column = IF ( OR ( CALCULATE ( COUNTROWS ( LinkedTable1 ) ) > 0, CALCULATE ( COUNTROWS ( LinkedTable2 ) ) > 0 ), "Yes" )
Try this COlumn
Column = IF ( OR ( CALCULATE ( COUNTROWS ( LinkedTable1 ) ) > 0, CALCULATE ( COUNTROWS ( LinkedTable2 ) ) > 0 ), "Yes" )
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
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" )
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!
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |