Forum Discussion

Icon for Responsive Resident rank

Responsive Resident

4 years ago

Solved

Measure or a Column question

Hi, Not sure if I need a measure or a calculated column. Looking for only those users who have PASSED in all the trainings they were enrolled in, which varies from 4, 5 or 6 any number. So in t...

Icon for Super User rank

Super User

4 years ago

The easiest way is to create a calculated column that flags the users that have passed all the tests.
Then depending on how you want to visualize, you can create a measure using the flag.

sraj
Responsive Resident
4 years ago
Do you mind showing how I can get the calculated column for this? Just showing on a table view
- Tutu_in_YYC
  Super User
  4 years ago
  Here is the calculation in DAX for the calculated column. It returns 1 if the user passed all the trainings. Let me know if it works.
  Flag =
  VAR WhichUser = 'Table'[User]
  VAR NoOfPasses =
  CALCULATE (
  COUNT ( 'Table'[PASS/FAIL] ),
  ALL ( 'Table' ),
  'Table'[User] = WhichUser,
  'Table'[PASS/FAIL] = "PASS"
  )
  
  VAR NoOfTrainings =
  CALCULATE (
  COUNT ( 'Table'[Training Name] ),
  ALL ( 'Table' ),
  'Table'[User] = WhichUser
  )
  
  RETURN
  IF ( NoOfPasses = NoOfTrainings, 1, 0 )
  - sraj
    Responsive Resident
    4 years ago
    That worked, I had other exceptions on there due to which I didnt see it all....but it works beautifully!! Thank you!!