Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I would like to set the color condition from 2 table which have already set the relationship betweem them. However, I have tried some times but didn't work. (it seems only set the condition from 1 table only)
Here is my idea on color condition from 2 table.
Table1[Value] = 'A' and Table2[Value2]= 'abc' then 'Red'
Table1[Value] = 'B' and Table2[Value2]= 'cdf' then 'Yellow'
Table1[Value] = 'C' and Table2[Value2]= 'cdf' then 'Green'
I tried the below but keep fail.
Solved! Go to Solution.
@manike , If you creating a new column then you have brought column from one table to another
say you want bring to Table 1 and table 1 is on many side in 1-M relation
then you can use
related(Table2[Value2])
otherwise try
Maxx(relatedtable(Table2),Table2[Value2]) //you can use minx, countx or sumx as per need
refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8
@manike , If you creating a new column then you have brought column from one table to another
say you want bring to Table 1 and table 1 is on many side in 1-M relation
then you can use
related(Table2[Value2])
otherwise try
Maxx(relatedtable(Table2),Table2[Value2]) //you can use minx, countx or sumx as per need
refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
30 | |
13 | |
11 | |
9 | |
6 |