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.
Hey all, First of all, thanks a lot already for the one who is willing to help me. Let me describe the situation : I have TABLE 1 with COLUMN 1 = PERNR I want to create a measure where I check if TABLE1.PERNR in TABLE2 COLUMN PERNR.
If value in TABLE1.PERNR not in TABLE2.PERNR the measure should be 1 , else 0.
I hope someone can help me out 🙂
Thanks a lot already!
KR,
Stef
Solved! Go to Solution.
Hi,
If you have one to one relationship between Table1 and Table 2, you could create a calculated column on Table1 with formula:
If(PERNR = Related(Table2.PERNR),"1","0")
Hope this helps.
Hi,
If you have one to one relationship between Table1 and Table 2, you could create a calculated column on Table1 with formula:
If(PERNR = Related(Table2.PERNR),"1","0")
Hope this helps.
Assuming you have no relationship between the two tables, you can use this measure expression in a table visual with your Table1[PERNR] column
IsThere =
VAR thispernr =
MIN ( Table1[PERNR] )
RETURN
IF (
ISBLANK (
CALCULATE (
COUNT ( Table2[PERNR] ),
Table2[PERNR] = thispernr
)
),
1,
0
)
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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 |
---|---|
108 | |
97 | |
79 | |
67 | |
60 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |