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.
Let me explain what i'm trying to do and maybe there is an easier way of doing this...
Table: Vulnerability
Vul System
x2123 xyzlaptop
x5252 xyzlaptop
x1235 abclaptop
x3421 deflaptop
Table: Disabled Systems
System
xyzlaptop
deflaptop
I want my report to only report on systems that have not been already disabled. Becuase i've already disabled the systems that have a vulnerability. So I thought I could just to a new comlumn if statmenet =IF vulnerability [system] = Disabled Systems [system],"True","False") However i just keep getting an error that what ever in the Disabled systems field can't be found because i'm trying to create the column in the vulnerability table... Any help is greatly appreicated.
Solved! Go to Solution.
Hi, assuming that both tables are related.
New Calculated Column:
Disabled = IF(COUNTROWS(RELATEDTABLE('Disabled System'))>0,"Yes","No")
Regards
Victor
Lima - Peru
Hi, assuming that both tables are related.
New Calculated Column:
Disabled = IF(COUNTROWS(RELATEDTABLE('Disabled System'))>0,"Yes","No")
Regards
Victor
Lima - Peru
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 |
---|---|
115 | |
100 | |
88 | |
70 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |