'Need help completing the measure with a date category
Can someone help me add this to the measure? Users falling in this category should be eligible and should have a flag of 1 too.
Flag = VAR WhichUser = 'User Performance'[Name] VAR NoOfPasses = CALCULATE ( COUNT ( 'User Performance'[PASS/FAIL] ), ALL ( 'User Performance' ), 'User Performance'[Name] = WhichUser, 'User Performance'[PASS/FAIL] = "Passed" )
VAR NoOfTrainings = CALCULATE ( COUNT ( 'User Performance'[Training Name] ), ALL ( 'User Performance' ), 'User Performance'[Name] = WhichUser )
RETURN IF ( NoOfPasses = NoOfTrainings, 1, 0 )
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
