DAX definitions
Exact source expressions and direct measure dependencies for the selected page.
% in Top Right Cell
NineBox · Talent Grid & Potential
VAR __base = FILTER(PerfEmployee, PerfEmployee[status] = "Active" && NOT ISBLANK(PerfEmployee[potentialRating]) && NOT ISBLANK(PerfEmployee[mostCurrentScore])) VAR __n = COUNTROWS(__base) + 0 VAR __g = COUNTROWS(FILTER(__base, PerfEmployee[mostCurrentScore] >= 4 && PerfEmployee[potentialRating] = "3 · High")) + 0 RETURN IF(__n < 10 || (__g > 0 && __g < 10) || (__n - __g > 0 && __n - __g < 10), BLANK(), DIVIDE(__g, __n))
Direct dependencies: None
High Performer Not High Potential Share
NineBox · Talent Grid & Potential
VAR __base = FILTER(PerfEmployee, PerfEmployee[status] = "Active" && NOT ISBLANK(PerfEmployee[potentialRating]) && NOT ISBLANK(PerfEmployee[mostCurrentScore]) && PerfEmployee[mostCurrentScore] >= 4) VAR __n = COUNTROWS(__base) + 0 VAR __g = COUNTROWS(FILTER(__base, NOT (PerfEmployee[potentialRating] = "3 · High"))) + 0 RETURN IF(__n < 10 || (__g > 0 && __g < 10) || (__n - __g > 0 && __n - __g < 10), BLANK(), DIVIDE(__g, __n))
Direct dependencies: None
High-Potential Share
NineBox · Talent Grid & Potential
VAR __base = FILTER(PerfEmployee, PerfEmployee[status] = "Active" && NOT ISBLANK(PerfEmployee[potentialRating])) VAR __n = COUNTROWS(__base) + 0 VAR __g = COUNTROWS(FILTER(__base, PerfEmployee[potentialRating] = "3 · High")) + 0 RETURN IF(__n < 10 || (__g > 0 && __g < 10) || (__n - __g > 0 && __n - __g < 10), BLANK(), DIVIDE(__g, __n))
Direct dependencies: None
Talent Grid Company Share
NineBox · Talent Grid & Potential
VAR __g = [Talent Grid Count] VAR __n = CALCULATE(COUNTROWS(FILTER(PerfEmployee, PerfEmployee[status] = "Active" && NOT ISBLANK(PerfEmployee[potentialRating]) && NOT ISBLANK(PerfEmployee[mostCurrentScore]))), REMOVEFILTERS(PerfEmployee)) RETURN IF(ISBLANK(__g) || __n < 10 || (__n - __g > 0 && __n - __g < 10), BLANK(), DIVIDE(__g, __n))
Direct dependencies: Talent Grid Count
Talent Grid Count
NineBox · Talent Grid & Potential
VAR __base = FILTER(PerfEmployee, PerfEmployee[status] = "Active" && NOT ISBLANK(PerfEmployee[potentialRating]) && NOT ISBLANK(PerfEmployee[mostCurrentScore])) VAR __n = COUNTROWS(__base) + 0 VAR __g = COUNTROWS(FILTER(__base, TRUE())) + 0 RETURN IF(__n < 10 || (__g > 0 && __g < 10), BLANK(), __g)
Direct dependencies: None
Talent Grid Text
NineBox · Talent Grid & Potential
IF(ISBLANK([High-Potential Share]) || ISBLANK([% in Top Right Cell]), BLANK(), "ILLUSTRATIVE: high potential " & FORMAT([High-Potential Share], "0.0%", "en-US") & "; top-right among rated " & FORMAT([% in Top Right Cell], "0.0%", "en-US") & ". Screening, not a verdict.")
Direct dependencies: High-Potential Share, % in Top Right Cell