Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |