Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
https://www.dropbox.com/s/4lbs0zlm799fi6n/Planning_Aid.pbix?dl=0
Hi,
I'm working on a system roll-out
Windows 7 Systems (Machines) have Applications (Packages) installed.
Some applications are ready for Windows 10 (Resultant Readiness = "YES")
Some applications are not ready for Windows 10 (Resultant Readiness = "NO")
A Windows 7 System is ready for Windows 10 only when all of its applications (100%) have a Resultant Readiness = "YES"
It's easy for me to tell which Location / Systems are NOT ready to migrate by slicing on Resultant Readiness = "NO" (this shows me the packages that are holding up migration for each Location / System)
I'd like to be able to see which sites / computers ARE ready to migrate (100% "YES")
I think I need a new measure that marks Systems as "Ready" or "Not Ready" based on the 100% "YES" or <100% "YES"
My objective is to have 2 additional charts where Systems / Locations would show up Green when Systems 100% "YES" and Red when Systems < 100% "YES" and to slice to show Ready Locations / Systems and Not ready Locations / Systems.
I have no idea how to set up a custom measure to do this - probably an additional column on the machine table that evaluates all application readiness?
Can you help me?
@Anonymous ,
You may try using CONTAINS.
Thanks so much for responding Sam Zha!
I'm having a bit of trouble implimenting (I'm very new to BI)
This report uses 3 tables:
Machine Information
Package information
MachineID vs PackageID Translation (ie a machine might have 100 applications (packages)
The CONTAINS code you suggested should be in a custom column in Machine Information?
Because I have to link to the information through the translation table I don't know how to format the code 😕
Something like this? Sorry for my stupidity!
Column = IF ( CONTAINS ( Package, Package[PackageID], Package[PackageID], Package[Resultant Readiness], "NO" ), "Not Ready", "Ready" )
I think it should look something like this, but when I enter it in I only see "Not Ready" in my "Machine_Ready" slicer, as it's evaluating the full package table - not the table related to the machine...
Machine_Ready = IF ( CONTAINS ( PACKAGE, PACKAGE[Resultant Readiness], "NO" ), "Not Ready", "Ready" )
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |