Forum Discussion

PowerBeeEye

Microsoft Employee

6 years ago

Solved

Value in table 1 exist/does not exist in table 2 for each entity

I have 3 tables: Servers Server_Name Server_OS Server_1 Windows Server 2016 Server_2 Windows Server 2019 Server_3 ...

Need Help

Fowmy

6 years ago

PowerBeeEye

Please check now:

You can download the file: HERE

Critical_Patch_Installed = 

VAR _UPDATE = 
SELECTCOLUMNS(
FILTER(
	GENERATE(
		'CVE-2020-1350',
		Q_Domain_Controllers_Hotfix_Latest
	),
	'CVE-2020-1350'[KBID] = Q_Domain_Controllers_Hotfix_Latest[HotFixID]
),
"_SERVER", Q_Domain_Controllers_Hotfix_Latest[ComputerDNS]
)

RETURN
IF( 
    SELECTEDVALUE(Q_Domain_Controllers_Latest[dnshostname]) IN _UPDATE,
    "Yes",
    "No"
)

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube LinkedIn

Fowmy

Super User

5 years ago

PowerBeeEye

You can download the file: HERE

To visualize the count based on YES/NO, create a table using the enter data option:

Add this measure:

Path Installs = 
COUNTROWS(
    FILTER(
        Q_Domain_Controllers_Latest ,
        [Critical_Patch_Installed] = SELECTEDVALUE('Path Installed'[Path Installed Status])
    )    
)

Show it in a column chart or any other suitable visual you prefer.